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
Ian Funnell —
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.