How to use Alteryx for an API POST

[CanadaKing]

Hi,

How could I use Alteryx in an API POST where I add a new line(s) to a table.

API request a JSON script that look like attached file

Thanks

[Luke_C]

Hi @CanadaKing 

Assuming you have columns for each field in the JSON, you would use a JSON Build tool to create the payload, and then use a download tool to create the POST request. How familiar are you with APIs? Any Sample data you can provide?

[CanadaKing]

Hi @Luke_C ,

I have a very little experience with Alteryx API, you may use attached file to the main post as data examples ....

Thanks

[gabrielvilella]

The file you attached is the JSON. Assuming you know how to build a JSON, you just need to use this as the payload when setting up the Download tool.

[Luke_C]

Hi @CanadaKing 

Here's how you can build the JSON if you're starting with raw data fields. Without having the API documentation it will be hard to give you the exact solution, but this should get you started.