Need Help Sending CSV file via API

[Jay2022]

Hi,

I'm not sure if that is possible but I would like to set a flow where I can send a CSV/Excel file via an API. So I would like for Alteryx to pick up an Excel/csv file, convert it into a 'json' file then upload/POST that file via an API. The trick is, I have to upload each row by themselves with the headers of course ( rows number can go from 3 to 30 depending on the day as the file will be different daily). On a regular basis I should have about 6 to 10 headers on  a regular basis.

For the API I have the URL information which include the client_secret,ID and grant_type keys.

Any help I can find to  help me build this would be greatly appreciated!!

[Jay2022]

@CoG   I was able to get this to work for the most part. All looks to work just fine until we get the download tool, I get the "Error transferring data " my url" : failure when receiving data from the peer" error message.  What could be hte issue here and how do I fix it. I inputed  my url, client_secret, client_id and grant_type in the API info inpu with their respective values.

[CoG]

If you are able to get the API to work with Postman, but not with Alteryx, then this may be a more complicated issue than I would be able to fix. It seems like there are many issues that could be involved that would need to be looked into, including whether you have a firewall/proxy server that may block the call, possibly Timeout settings, using the AMP engine (for one user that I found in another community post), the Alteryx Version you are using, etc.

You could post this as a separate community post if you would like fresh eyes on this problem, or you can also file a support ticket with Alteryx.

Out of curiosity, did you try building the non-macro version that was suggested earlier in this thread, just converting each row to JSON and running the whole table through the Download Tool?

[Jay2022]

@apathetichell  are you able to provide a sample for better understanding?