topic Re: tRestResponse Json not displaying all rows in Talend Studio

tRestResponse Json not displaying all rows

Cherichoc- — Sat, 16 Nov 2024 03:04:40 GMT

Goal is to enter account nr on url then it pulls all accounts and devices linked to it.

My tRestresponse only displays one row as results

{"LINK":{"accounts":{"accountnr":"EEE","entityname":"Ku","entid":93},"devices":{"devid":129,"devicename":"Ku Bha Service Station"}}}

While tlog displays all rows

{"LINK":{"accounts":{"accountnr":"EEE","entityname":"Ku","entid":93},"devices":{"devid":129,"devicename":"Ku "}}}
{"LINK":{"accounts":{"accountnr":"AAA","entityname":"Ku2","entid":93},"devices":{"devid":155,"devicename":"Ku2 "}}}

Re: tRestResponse Json not displaying all rows

TRF — Thu, 05 Mar 2020 11:15:47 GMT

As we can't guess what it looks like, share your job design + settings for related components

Re: tRestResponse Json not displaying all rows

Cherichoc- — Thu, 05 Mar 2020 11:21:18 GMT

Re: tRestResponse Json not displaying all rows

Cherichoc- — Thu, 05 Mar 2020 12:54:00 GMT

I just needed to add on tXMLmap all in one = true.

Re: tRestResponse Json not displaying all rows

Cherichoc- — Thu, 05 Mar 2020 13:08:27 GMT

@TRF

@kzone

@rhall

I now need to display the Json document much neater. currently it looks like

where do I make this changes for Json to display as above

Re: tRestResponse Json not displaying all rows

TRF — Thu, 05 Mar 2020 13:50:32 GMT

Short answer: nowhere.

Don't format the JSON within the job, this is not necessary.

You just need it when a human have to read it.

In this case use your prefered text editor functionality to format the JSON flow.

If your text editor doesn't allow you to do that, change it! Notepad++ (for example) is able to do that.

Re: tRestResponse Json not displaying all rows

Cherichoc- — Fri, 06 Mar 2020 06:51:31 GMT

@TRF
@kzone @rhall

There is the loop sequence option I read about on txmlMap (...) next to loop

but I happen to not have the edit loop sequence. I'm I missing something

Re: tRestResponse Json not displaying all rows

Anonymous — Fri, 06 Mar 2020 17:44:53 GMT

I'm sorry I am not sure what you are asking for. Can you explain in a bit more detail. Maybe point to where you read about this and give an example of what you are trying to achieve.

Re: tRestResponse Json not displaying all rows

Cherichoc- — Tue, 10 Mar 2020 09:50:06 GMT

Re: tRestResponse Json not displaying all rows

Cherichoc- — Tue, 10 Mar 2020 09:54:19 GMT

@rhallI'm trying to display the json in an array as above. I managed to loop

Re: tRestResponse Json not displaying all rows

Anonymous — Tue, 10 Mar 2020 11:07:17 GMT

If you want to add an array to the JSON you need to build it with a tWriteJSONField component and not a tXMLMap. Arrays are not native to XML so when the XML is converted to JSON it will return the data as a loop of elements.

I've just knocked up a quick example. It is very basic, but should give you an idea. My job looks like this...

My tFixedFlowInput component holds this data....

I'm aiming for the "newColumn1" values to be in an array.

I configure the tWriteJSONField's mapping as below.....

Then I set the "Group By" field to group by the "newColumn" column (...the column I set my Loop on).

The output I get can be seen below....

{"rootTag":{"newColumn":["newLine","newLine","newLine","newLine"],"newColumn1":"1"}}

....or in a more readable format.....

{
   "rootTag":{
      "newColumn":[
         "newLine",
         "newLine",
         "newLine",
         "newLine"
      ],
      "newColumn1":"1"
   }
}

Re: tRestResponse Json not displaying all rows

Cherichoc- — Wed, 11 Mar 2020 06:43:42 GMT

@rhall that's great but my problem now is linking

restRequest-->tsetGlobalVar--->tdbRow--->tfixedFlowInput

It doesn't allow main link

Re: tRestResponse Json not displaying all rows

Anonymous — Wed, 11 Mar 2020 09:55:12 GMT

You don't need to use a tFixedFlowInput component. I simply used that to hardcode my example data. Your data will not be hardcoded. The only component you care about in my example is the tWriteJsonField