How to design pipeline to get data from REST (produces JSON) to map to SQL database?
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.
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!
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.
