Json API call data capture

UI Builder
1

Hi - I am tryting to capture specific content from json payload and seems to be having issues.
I am able to get everything else just that 2 things listed in the screenshot. Help please.
I need “cursor” and “remaining” values.

image
image1359×816 98.1 KB

image
image767×134 14.7 KB

2

Can you show the full JSON response from the external service as text? (Not image)

3 
{ cursor: 0, results: [ { acct_no: 107364, item_no: 230, order_no: '500003', order_qty: 10, 'Created By': 'admin_user_gb-online-ordering_test', 'Created Date': '2023-02-23T19:01:09.446Z', 'Modified Date': '2023-03-02T03:06:15.228Z', status: 'Completed', delivery_date: '2022-02-24T08:00:00.000Z', email_order_info: 'Item# 230 - Qty (10)', order_no_fe: '640224', item_no_t: '230', _id: '1677178869446x482759657364468800' }, { acct_no: 107364, item_no: 1036, order_no: '500003', order_qty: 0, 'Created By': 'admin_user_gb-online-ordering_test', 'Created Date': '2023-02-23T19:01:09.447Z', 'Modified Date': '2023-03-02T03:06:15.276Z', status: 'Completed', delivery_date: '2022-02-24T08:00:00.000Z', email_order_info: 'Item# 1036 - Qty (0)', order_no_fe: '640224', item_no_t: '1036', _id: '1677178869447x533468048905711300' }, { acct_no: 107364, item_no: 503, order_no: '500003', order_qty: 15, 'Created By': 'admin_user_gb-online-ordering_test', 'Created Date': '2023-02-23T19:01:09.447Z', 'Modified Date': '2023-03-02T03:06:15.337Z', status: 'Completed', delivery_date: '2022-02-24T08:00:00.000Z', email_order_info: 'Item# 503 - Qty (15)', order_no_fe: '640224', item_no_t: '503', _id: '1677178869447x643653346436100200' }, { acct_no: 107364, item_no: 1038, order_no: '500003', order_qty: 5, 'Created By': 'admin_user_gb-online-ordering_test', 'Created Date': '2023-02-23T19:01:09.448Z', 'Modified Date': '2023-03-02T03:06:15.423Z', status: 'Completed', delivery_date: '2022-02-24T08:00:00.000Z', email_order_info: 'Item# 1038 - Qty (5)', order_no_fe: '640224', item_no_t: '1038', _id: '1677178869448x216157925782892300' }, { acct_no: 106127, item_no: 503, order_no: '500004', order_qty: 0, 'Created By': 'admin_user_gb-online-ordering_test', 'Created Date': '2023-02-23T19:01:09.448Z', 'Modified Date': '2023-03-02T03:06:15.455Z', status: 'Completed', delivery_date: '2022-02-24T08:00:00.000Z', email_order_info: 'Item# 503 - Qty (0)', order_no_fe: '270224', item_no_t: '503', _id: '1677178869448x563927531952961300' } ], count: 5, remaining: 5240 }```
4

Is this what the external service returns or what one of your print statements prints? I do not see the “response” property. Need to understand what I am looking at.

5

{
“response”: {
“cursor”: 0,
“results”: [
{
“acct_no”: 107364,
“item_no”: 230,
“order_no”: “500003”,
“order_qty”: 10,
“Created By”: “admin_user_gb-online-ordering_test”,
“Created Date”: “2023-02-23T19:01:09.446Z”,
“Modified Date”: “2023-03-02T03:06:15.228Z”,
“status”: “Completed”,
“delivery_date”: “2022-02-24T08:00:00.000Z”,
“email_order_info”: “Item# 230 - Qty (10)”,
“order_no_fe”: “640224”,
“item_no_t”: “230”,
“_id”: “1677178869446x482759657364468800”
},
{
“acct_no”: 107364,
“item_no”: 1036,
“order_no”: “500003”,
“order_qty”: 0,
“Created By”: “admin_user_gb-online-ordering_test”,
“Created Date”: “2023-02-23T19:01:09.447Z”,
“Modified Date”: “2023-03-02T03:06:15.276Z”,
“status”: “Completed”,
“delivery_date”: “2022-02-24T08:00:00.000Z”,
“email_order_info”: “Item# 1036 - Qty (0)”,
“order_no_fe”: “640224”,
“item_no_t”: “1036”,
“_id”: “1677178869447x533468048905711300”
},
{
“acct_no”: 107364,
“item_no”: 503,
“order_no”: “500003”,
“order_qty”: 15,
“Created By”: “admin_user_gb-online-ordering_test”,
“Created Date”: “2023-02-23T19:01:09.447Z”,
“Modified Date”: “2023-03-02T03:06:15.337Z”,
“status”: “Completed”,
“delivery_date”: “2022-02-24T08:00:00.000Z”,
“email_order_info”: “Item# 503 - Qty (15)”,
“order_no_fe”: “640224”,
“item_no_t”: “503”,
“_id”: “1677178869447x643653346436100200”
},
{
“acct_no”: 107364,
“item_no”: 1038,
“order_no”: “500003”,
“order_qty”: 5,
“Created By”: “admin_user_gb-online-ordering_test”,
“Created Date”: “2023-02-23T19:01:09.448Z”,
“Modified Date”: “2023-03-02T03:06:15.423Z”,
“status”: “Completed”,
“delivery_date”: “2022-02-24T08:00:00.000Z”,
“email_order_info”: “Item# 1038 - Qty (5)”,
“order_no_fe”: “640224”,
“item_no_t”: “1038”,
“_id”: “1677178869448x216157925782892300”
},
{
“acct_no”: 106127,
“item_no”: 503,
“order_no”: “500004”,
“order_qty”: 0,
“Created By”: “admin_user_gb-online-ordering_test”,
“Created Date”: “2023-02-23T19:01:09.448Z”,
“Modified Date”: “2023-03-02T03:06:15.455Z”,
“status”: “Completed”,
“delivery_date”: “2022-02-24T08:00:00.000Z”,
“email_order_info”: “Item# 503 - Qty (0)”,
“order_no_fe”: “270224”,
“item_no_t”: “503”,
“_id”: “1677178869448x563927531952961300”
}
],
“count”: 5,
“remaining”: 5240
}
}

6

Thanks. The problem is right here:

Json API call data capture - UI Builder - Backendless Support 2023-04-21 18-29-47
Json API call data capture - UI Builder - Backendless Support 2023-04-21 18-29-471339×803 189 KB

The “cursor” property is there, but it is not in the array elements. The “Map items in list” will iterate over a list, however, the value you pass into the “Map” block is an object. Same goes for the “remaining” property.

7

Perfect, that was it Mark!