Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to retrieve attributes of last row of JSON result from tREST

I am using a tREST component to retrieve data. All works well and I am able to extract the values of the first row of the array returned, but I am having difficulties extracting the values of the last row. See below setup of the tExtractJSONFields component. 

 

The problem is that history[-1:] returns a list unlike history[0] which returns the element. 

How do I need to write history[-1:].date to get the date and not a list with the date in it?

In my setup it returns ["2020-01-03T09:37:26.030Z"] for the date but I need to have "2020-01-03T09:37:26.030Z"

 

0683p000009M9Fq.jpg

Labels (2)
0 Replies