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
WarrenBelz
146,645
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,997
Most Valuable Professional
Share
Report
All responses (
Answers (
