Forum Discussion

Shirali's avatar
Shirali
New Contributor
6 years ago

How can I convert Excel File to CSV file?

I am trying to convert the Excel file to CSV using Excel Parser and CSV formatter is that the right way to go with?
cstewart's avatar
cstewart
Former Employee
3 years ago
Copy LinkReport

The API you are using will return you a list of runtimes, with summary data. If you take the RUUID from that make another request with the RUUID in the request too, you get the more detailed info.

vincenr's avatar
vincenr
New Contributor III
3 years ago
Copy LinkReport

Hi Craig,

Just wondering why you had to do all the ternary comparisons with state and hours to get the call to work? Is that analogous to SQL where if sometimes you don’t deal with nulls correctly you won’t get all the results or get incorrect results?

  • koryknick's avatar
    koryknick
    Employee
    3 years ago
    Copy LinkReport

    @vincenr - The ternary statements will optionally include the state, hours, last_hours, and limit query parameters to the API call. The values for these are coming from pipeline parameters so you can configure that at run time rather than have them hardcoded into the call.