Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Cherichoc-
Creator
Creator

tRestResponse Json not displaying all rows

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 "}}}

 

 

 

Labels (6)
1 Solution

Accepted Solutions
Cherichoc-
Creator
Creator
Author

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

 

 

View solution in original post

12 Replies
TRF
Champion II
Champion II

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

0683p000009M9q5.png

0683p000009M9uC.png

Cherichoc-
Creator
Creator
Author

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

 

 

Cherichoc-
Creator
Creator
Author

 @TRF 

@kzone 

@rhall 

 

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

0683p000009M9q1.png

 

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

 

 

 


  
 

TRF
Champion II
Champion II

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.

Cherichoc-
Creator
Creator
Author

@TRF 
@kzone @rhall 

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

0683p000009M9yb.png

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

0683p000009M9yg.png

 

 

Anonymous
Not applicable

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.

Cherichoc-
Creator
Creator
Author

0683p000009MA2s.png0683p000009MA2x.png0683p000009M9sV.png

Cherichoc-
Creator
Creator
Author

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