Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here

Alteryx workflow receiving a JSON file from Postman

Highlighted
5 - Atom

Hi, 

 

I am new to Alteryx and have a project that I am currently working on for my Company. We are currently building an API that will send a schema to the Alteryx workflow that I am trying to build. The schema will come as a JSON. In the meantime, I will conduct testing with Postman where I am going to send the schema to the workflow (once I know what tool to use). I did some research and I only see the "Download Tool" where it does a GET but I do not have a URL that I am getting information from (ex. Postman). Any ideas?

Highlighted
Alteryx
Alteryx

 

Hi @kelvinz - I navigated over to an article I found on the postman blog (https://blog.postman.com/using-csv-and-json-files-in-the-postman-collection-runner/) - in that article, I found a sample postman file in json format. Is that similar to what you will have available for input?

 

If so, you can use a standard Input Data tool - here's how I configured mine...note the change to the Code Page - Unicode UTF-8:

BrianR_0-1593645317984.png

 

From here, it will be a bit of a parsing exercise to extract the needed info, but hopefully this is along the lines of the types of files you will be receiving.

 

 

 

Highlighted
7 - Meteor

Hi @kelvinz I've attached a workflow using a partner tool thats very easy. It does the JSON parsing for you, and works well with Postman.  Hope this helps.  Here is link to blog for the partner solution. Attached doc provides the exact workflow for your use case.

 

https://community.alteryx.com/t5/Analytics-Blog/Precog-Alteryx-A-Slam-Dunk-Analytics-Partnership/ba-...

 

Hope it helps.

Jeff

Labels