nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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!!

API

Accepted answers

CoG

Here is a general framework based on what I know so far, little details may have to be adjusted as necessary based on your specific requirements (specifically with the Download Tool, and the Tool Container that is currently essentially empty):

Sample Macro.yxmc

All comments

CoG

This sounds like a job for either a batch or an iterative macro (I would lean toward iterative myself), but either should work just fine.

Jay2022

How would you proceed with that?

CoG

Sample Macro.yxmc

Jay2022

I beginning to understand it...what would the 2 outpu tools be in this case? a regular output?

CoG

For iterative macros, I follow a standardized system (as an initial note: Iterative Macros require 2 Macro Output Tools for proper functionality).

My first Macro Output Tool (on top) is called Complete and is assigned the anchor initial 'C'. This is the output I use for the successful output of the iterative macro.
My second Macro Output Tool (on bottom) is called Iterate and is not assigned an anchor initial. All records that output here will become the new input for the next iteration (This part is set up in View -> Interface Designer -> Settings)
The macro will thus sample the first record from your data, call the API, and send all other records after the first back through macro until no records remain or the Max Iteration Number is reached (also defined in Interface Settings), which for 30 records should never happen.

More Info. can be found here on iterative macros: https://knowledge.alteryx.com/index/s/article/Getting-Started-with-Iterative-Macros-1583461640389

apathetichell

I don't think this is neccesarily a macro situation - but have you used this API before @Jay2022 or do you just have the credentials? I'd check with postman and figure out the proper syntax for uploads there - FIRST.

After you have the json syntax down (and make sure your credentials work) you'd create a key (ie a rowid) do some transposing, and build a a new datastream of credentials/endpoint/constructed json. then the download tool will execute for each entry that you have.

Jay2022

I am a fair beginner Alteryx user so the iterate macro sounds a bit challenging for me. I will start working on it and try to fin help to set it up. Thank you for the explanation that will help a lot!!

Jay2022

I have not used the API prior to now. I'm trying to set it up based on what the vendor provided me. So far, once I send the POST resquest it does seem to work per POSTMAN as I received the Ok status. The pretty body gives me an access token, token type, expiration and scope but does not show the file nor data. I need to see the data in the file with both headers and value for each row that is passing through.

Is there a way I can do that in POSTMAN?

Jay2022

@CoG , I had a tought, what if I was trying to send out an actual json file but wanted to send one row/case at the time?

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?

Quick Links

Popular Tags

This months top contributors

atcodedog05 19598

Qiu 15908

binu_acs 15783

MarqueeCrew 13709

apathetichell 13703