You’re offline. This is a read only version of the page.
I am attempting to get the below parsed JSON into an array and simply cannot. I've been looking through forums all day and while there are some promising similar articles, I cannot get them to work. Any attempt to add the Body or Item to an Array variable or inside a Select data operation gives the error "The 'from' property value in the 'select' action inputs is of type 'Object'. The value must be an array." or something similar when trying to set an array; it keeps saying the data is an object, not an array. Any help is much appreciated.
From ParseJSON output:
Hi @jh_ojh ,
Please fill in a pair of square brackets outside this code, similar to this:
[
{
"data": [
{
"id": "d329b2f6-226b-4c7b-9821-f014e4328e61",
"individual": {
"birth_date": "1990-02-02T00:00:00.000Z",
"communications": [
{
"id": "003D600001J9ibwIAB",
"type": "Cell Phone",
"value": "678-900-2891"
}
],
"first_name": "Automation",
"geo_locs": [
{
"city": "Pleasantville",
"id": "003D600001J9ibwIAB",
"line1": "Placeholder Street 1",
"line2": "Placeholder Street 2",
"line3": "",
"postal_code": "01040",
"state": "MA",
"type": "Mailing"
}
],
"id": "2eeae16a-1013-4c16-ae9b-5881ff3c9545",
"last_name": "Automation",
"local_office_assignments": [
{
"id": "14703742-1d31-47c7-bc12-574f85ef7944",
"local_office": "Team A",
"local_office_id": "ba78abb0-674c-46dc-8488-0b3b0b468613",
"party_local_office_assignment_type": "Primary",
"party_local_office_assignment_type_id": "d3d33812-3546-44ea-a60e-681a1bcd1585"
}
],
"referral_source": {
"id": "1caafd99-ace0-4af2-804a-1905a2b751b0",
"referral_source": "",
"referral_source_type": "Friend or family member"
}
},
"offering": "DAF",
"offering_id": "c1b6a595-dafb-4262-84e8-21ba90625b94",
"offering_request_detail": {
"es1_acct_id": "67882",
"id": "057ddfdf-978a-4019-bf97-0670c6841404",
"name": "The Automation App",
"status": "Opened"
},
"offering_type": "New Offering",
"offering_type_id": "81e9e4c8-323f-4c8d-8f62-e3d97fc75f65",
"request_date": "2024-05-01T15:14:49.073Z"
}
],
"errors": [],
"metadata": {
"client_tracking_id": "08584846870285838889206808641CU00",
"response_count": 17
}
}
]
Best Regards,
Sunshine Gu
#1
rpersad
16
#2
David_MA
10
Super User 2025 Season 1
#3
Michael E. Gernaey
8
Super User 2025 Season 1
Share
Report
All responses (
Answers (
