topic Extract API data and using tExtratDelimtedFileds and tNormalize in Talend Studio

Extract API data and using tExtratDelimtedFileds and tNormalize

Cherichoc- — Fri, 15 Nov 2024 23:14:29 GMT

I have a job that extracts data from an API.

My struggle is extracting the data from the API to columns in tExtractDelimetedFields. The API data is something like:

[{"Day": 01","Name":"John",Surname":"Doe","Attended":"Yes"},{"Day": 01","Name":"Peter",Surname":"Pan","Attended":"No"},

,{"Day": 01","Name":"Cindy",Surname":"Rella","Attended":"Yes"}]

The expected results is for the fields to be in a table in their columns which i will be able to do.

Not sure if my item separator is correct as i am not familiar with regex

tExtractDelimitedFiled field separator as well, my input fields are body and error_msg, outputfields are Day, Name, surname, attended

gjeremy1617088143 — Mon, 07 Feb 2022 14:49:07 GMT

Hi, you can use tExtractJSONFields component, it will fit better for your use.

https://help.talend.com/r/en-US/7.3/processing/textractjsonfields

Send me love and kudos

Cherichoc- — Mon, 07 Feb 2022 15:20:32 GMT

How would I Loop jsonPath query and also map the columns

gjeremy1617088143 — Mon, 07 Feb 2022 16:08:13 GMT

I've tried with this Json :

[{"Day":"01","Name":"John","Surname":"Doe","Attended":"Yes"},

{"Day":"01","Name":"Peter","Surname":"Pan","Attended":"No"},

{"Day":"01","Name":"Cindy","Surname":"Rella","Attended":"Yes"}]

I used tFileInputRaw and tConvertType to simulate your json return from api

Anonymous — Mon, 07 Feb 2022 16:09:25 GMT

I cover this in a series of tutorials/blogs about working with Slack. You can find tutorial 2 here....

https://community.talend.com/s/article/Sending-Slack-messages-with-Talend-part-2-Collecting-your-Slack-data

At steps 8 and 18 I show how to iterate over arrays in JSON.