Setup a custom Post call to Rest API using Atteryx

Hello Alteryx community,

I am currently in the process of passing a call to an API. Some of the data for this call is present in a column in Alteryx which would be a set of numbers in rows within a Part Number column whose datatype is a "V_String". Please find the example table and API call below.

Sample Table

Part Number	Part Name	Part Available
12345678A	NUT	Y
14567890A	BOLT	N
98765432A	ENGINE	N
32109876A	CHASSIS	Y

Sample API Call/Request

{

"companyCode": "TST01",

"partNumbers": [

{

partNumber": "12345678A"

{

"partNumber": "14567890A"

{

"partNumber": "98765432A"

{

"partNumber": "32109876A"

}

]

}

Can anyone please help me on how to achieve this? I tried to use "Report Text" feature in documentation, but that seems to be somewhat rather an hassle and I wasn't able to achieve it. If possible, is there a way where we could run a Multi-Row formula and generate the API request and create a new Column with the complete request in one single row or whatever the best possible way to solve this scenario.

Thank you,

Sachit

Input

Best Practices

API

Help

Accepted answers

apathetichell

use transpose. Then build a Json pair using name/value. Use summarize tool to build this into one payload. Use download tool for your api.

All comments

apathetichell

use transpose. Then build a Json pair using name/value. Use summarize tool to build this into one payload. Use download tool for your api.

ssripat3

Just one other small help if possible. I am trying to use Regex to Parse through JSON_Name column and get particular values which match the criteria.

JSON_Name	JSON_Name_After_Regex_Parse
result.Parts.0.mfgPart.partPrefix	partPrefix
result.Parts.0.mfgPart.partBase	partBase
result.Parts.0.mfgPart.partSuffix	partSuffix
result.partnerParts.0.partnerPartNumber	partnerPartNumber
result.partnerParts.0.partnerPartName	partnerPartName
result.partnerParts.0.partnerPartCompanyName	partnerPartCompanyName

Can anyone please help on how to achieve this?

I referred this article. But those methods didn't work for me as I was unable to specify "." as a character in the Regex.

Solved: Regex extracting after last underscore - Alteryx Community

Luke_C

Hi @ssripat3

This should work. In regex a period is typically used to reference a character. In order to literally specify a period you need to prefix it with a slash (escape character).

.*\.(.*)

apathetichell

I used regex_replace([JSON_Name],"(\w+\.\d+\.)(\w+.*)$","$2") recently which should get you what you need. if you want the number to use in crosstabbing you could do:

([JSON_Name],"(\w+\.)(\d+)(\.)(\w+.*)$","$2") - to get the record number and

([JSON_Name],"(\w+\.)(\d+)(\.)(\w+.*)$","$4") - to get the JSON name

this assumes there are no non-word characters in any field names which worked in my case.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703