
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-17-2021 11:50 AM
I am stuck in a flow designer Flow on how to only get the first element from an array of objects.
I am using a REST action I built to pull back all the shipping tracking history based on a tracking number. One of the fields is 'actions' and the first action listed is the most recent action which is all I want.
So now that I have an output from my flow action step that set a variable as an array of objects for 'actions' I just want to get the first element.
I see the logic tool ForEach but I just want the first one and then end.
I'm not sure how to indicate the element I am looking for from the array.
Solved! Go to Solution.
- Labels:
-
Studio

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-17-2021 01:06 PM
Have you looked into Utilities. There's an option for getting item from the array. index starts at 0 so in your case you are looking for 0th item from the array
https://docs.servicenow.com/bundle/paris-servicenow-platform/page/administer/flow-designer/reference/utilities-transform-functions.html

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-17-2021 01:06 PM
Have you looked into Utilities. There's an option for getting item from the array. index starts at 0 so in your case you are looking for 0th item from the array
https://docs.servicenow.com/bundle/paris-servicenow-platform/page/administer/flow-designer/reference/utilities-transform-functions.html

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-22-2021 07:37 AM
I tried that utility but am still getting all rows:
output variable name is latestActivity as array.object type
Raw input is array.object
{ "latestActivity": { "Activity": [ { "Activity": { "ActivityLocation": { "Address": { "City": "BEVERLY", "CountryCode": "US", "PostalCode": "01915", "StateProvinceCode": "MA" }, "Code": "ML", "Description": "Front Door" }, "Date": "20201210", "GMTDate": "2020-12-10", "GMTOffset": "-05:00", "GMTTime": "16:41:51", "Status": { "StatusCode": { "Code": "FS" }, "StatusType": { "Code": "D", "Description": "Delivered" } }, "Time": "114151" } },
{ "Activity": { "ActivityLocation": { "Address": { "CountryCode": "US" }, "Description": "Front Door" }, "Date": "20201209", "GMTDate": "2020-12-10", "GMTOffset": "-05:00", "GMTTime": "00:13:55", "Status": { "StatusCode": { "Code": "MP" }, "StatusType": { "Code": "M", "Description": "Shipper created a label, UPS has not received the package yet." } }, "Time": "191355" } } ] } }
Maybe I have the Output variable setup incorrectly? I am attaching a screenshot of the setup I have that is still outputing all the Activity elements, not just the first one.