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; } } }

API http POST - Loop/Array - Works in Postman

Alc2020

Hi,

I am new to Alteryx Designer. I have the following sample data in json. I can upload these data in Postman using iteration with no issues. How can we automate this in Alteryx Designer? I was trying with the Download tool but cannot get success. Do I need to use other Alteryx tool to solve this?

Thank you in advance!

data.json

[
	{
		"cusomerId": 9000,
		"productId": 5
	},
	{
		"cusomerId": 9001,
		"productId": 4
	},
	{
		"cusomerId": 9002,
		"productId": 3
	}
]

4-Postman Success Run Result.jpeg

1-Postman Body.jpeg

2-data.json.jpeg

4-Postman Data Preview.jpeg

3-Postman Runner.jpeg

API

Accepted answers

BrandonB

There will be one row coming out of the download tool for each url and payload passed in. You can parse the JSON results from the download data column using the JSON Parse tool.

Alc2020

Thank you very much for the tips. This is now resolved.

Awesome! @BrandonB

I ended up like the workflow snapshot attached. 🙂

BrandonB

Thank you for sharing!

All comments

BrandonB

Have you gotten it to work with one of the JSON brackets? Make sure that the HTTP action is set for what you want in the payload tab, and put your JSON in the section down at the bottom "Use Following for Query String/Body"

{
		"cusomerId": 9000,
		"productId": 5
	}

BrandonB

From your screenshot it looks like you are using the POST HTTP action so make sure that dropdown is set appropriately.

Alc2020

Hi,

It works for single transaction only in Alteryx via Input tool and Download
tool (http post). I'm looking for bulk automation. In this example, I
wouod like to upload three records at once.

Thanks

Quick Links

Popular Tags

This months top contributors

atcodedog05 19598

Qiu 15907

binu_acs 15783

MarqueeCrew 13709

apathetichell 13703