Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

Handling a CSV report from an API request

I am making requests against an API which returns a CSV output. I have used the function jsonproviderGet and xmlproviderGet successfully in the past, but it seems like the API Profile doesn't support csvproviderGet?

The operation 'csvproviderGet' could not be found.

Is there another way I should be handling CSVs?

1 Community Answers

Matillion Agent  

Ian Funnell —

Hi Joshua,

No, there’s no csvproviderGet unfortunately, so you can’t use the API Query component with an API that returns CSV data.

The workaround is to call the API yourself (for example using curl from a Bash Script component), save the CSV file to S3, and then use the normal bulk loader afterwards.

Best regards,
Ian

Post Your Community Answer

To add an answer please login