How to design pipeline to get data from REST (produces JSON) to map to SQL database?

qwertyuiop1 — Sat, 16 Nov 2024 01:40:38 GMT

Hi,

I currently have a REST endpoint with JSON data that I want to eventually map to a MS SQL DB so I can use tLogRow first (if easier). I have attached the sample data below.

The current components I am using are:

tRestClient -> tExtractJSONFields -> tMap -> tLogRow/tDBOutput

I have gotten the tRestClient component to work on its own. (I also tried out tRestRequest and it worked on its own too)

However, once I connect it to the other components, I hit a wall. I tried editing the schema of the tRestRequest but there seems to be only "key" and "value" as the response schema. I'm not sure how to capture my 3 needed columns: role, firstname, and groups.

If anyone can help me out, I would greatly appreciate it. Thank you!

Re: How to design pipeline to get data from REST (produces JSON) to map to SQL database?

Anonymous — Wed, 19 Aug 2020 09:10:50 GMT

Link tRestClient to tXMLMap and extract the data from returned document. Or use tRest to call API and use tExtractJSONFields to extract data from Json string.

Regards

Shong

topic Re: How to design pipeline to get data from REST (produces JSON) to map to SQL database? in Talend Studio

How to design pipeline to get data from REST (produces JSON) to map to SQL database?

Re: How to design pipeline to get data from REST (produces JSON) to map to SQL database?