JSON Response body is an array, parse using script step not working

Chad R · ‎12-18-2023

Hello All!

I have beat my head against the wall for awhile, first I will say I know the JSON Parser step will do what I'm about to ask about but I am trying to see if I can do this without it for obvious reasons :).

First I have a JSON response body form a third party that I go and get and I am attempting to parse that into an object and feed it into an output to use in designer flows. First here is the very large and ugly response body:

{

"ReceiveMessageResponse": {

"ResponseMetadata": {

"RequestId": "1808480e-ebc9-5f83-bbe1-15f4b3fbb859"

},

"ReceiveMessageResult": {

"messages": [

{

"MessageId": "7b1a126b-e895-4d93-a559-de50291e45a4",

"ReceiptHandle": "AQEBF8HfWTWyRVMKeGe2HGWVJZ8wq9QKTa7hbVrX+8pqK/TP1SUHln9h/lUPdQ2RSuO8qVog0+uANGY2UMHbmV1P4DL0EkhcaBcKuZqhiyOxJVFiGR9pxZNURRDlO2u6iyZW3s9ja2bozk4oIEtD8xQFmviqdXGlvAbYer3P2914h0/PgHC8xWm8txynlw3BqWB2zfBFsH4S19e6jLgsNdGtBLZe0NHCfSfgIU0mkwkZW5Jko2mNOZMhIYIKw7oIKlkeaTP4F9PNmBzuyAZBhMc2bowtP2ZJ3+luBW9AYx7cr2A=",

"MD5OfBody": "f2049eb6afe382aeff2509c02905b3db",

"Body": {

"clientName": "Conduent Business Services Global",

"ticketNumber": "e-CS001333807",

"clientTicketNumber": "",

"ticketType": "Incident",

"status": "open",

"description": "test\r\n\r\nHELLO WORLD",

"shortDescription": "test",

"group": "Ensono MF CICS",

"ensonoGroup": "MF - GTS CICS",

"priority": "4",

"impact": "4",

"urgency": "4",

"openedTime": "2023-12-14T18:20:42Z",

"category": "Azure",

"origin": "Internal Request",

"cis": ""

},

"Attributes": {

"SenderId": "AROAYCQITFFPIEBOQI2KM:envxsn2qdev1SN2QBridge",

"ApproximateFirstReceiveTimestamp": "1702578111786",

"ApproximateReceiveCount": "34",

"SentTimestamp": "1702578096232",

"SequenceNumber": "37329348140054496000",

"MessageDeduplicationId": "38770e8d565e24fa4dd2db1ddd85d4c713728bebf6eafec76f7c91574874d7f5",

"MessageGroupId": "e-CS001333807",

"AWSTraceHeader": "Root=1-657b47af-4c0f31211b35a2b1051f0cf3;Parent=141b9e3d75ea8d4a;Sampled=0;Lineage=eac5e8ee:0",

"ClientReferenceAvailable": false,

"TransactionType": "Create"

}

},

{

"MessageId": "e27eb7fc-b09e-49b8-8e78-127941cc1310",

"ReceiptHandle": "AQEBUXyz9uVJFvCwdqhrWw38G7qJkIHh+GILFohX524p350nGOXtaDTAfXI2RuDStoNt0A0IscyGcO6tcd/AqbIbfoMz0Pdnww2F4yO8ipDjV73h9p1VH85SGrk/Ln2MCr8opVXEThMsl78O0tqNjvpQh8RJrqWyXPopaYSTIIrWTGTxRlUtQ5CnFvmqG1FWA+OnfIfa1HYfFi//IyNJZbG5bFXgTNznAWvVtvtMnfId0cMqPsttl9D/O4hmRGMuJc8NhAXgye9rOB/zI4J9wpXSc4pHl/Re01Pe9kBvZqB7hws=",

"MD5OfBody": "1173c47afc2501d26e6104909b958a3d",

"Body": {

"clientName": "Conduent Business Services Global",

"ticketNumber": "e-CS001333807",

"clientTicketNumber": "",

"ticketType": "Incident",

"status": "open",

"description": "test\r\n\r\nHELLO WORLD",

"shortDescription": "testing update",

"group": "Ensono MF CICS",

"ensonoGroup": "MF - GTS CICS",

"priority": "4",

"impact": "4",

"urgency": "4",

"openedTime": "2023-12-14T18:20:42Z",

"category": "Azure",

"origin": "Internal Request",

"cis": "",

"changed": {

"updatedOn": "2023-12-14T18:22:31Z",

"shortDescription": "testing update"

},

"updatedOn": "2023-12-14T18:22:31Z"

},

"Attributes": {

"SenderId": "AROAYCQITFFPIEBOQI2KM:envxsn2qdev1SN2QBridge",

"ApproximateFirstReceiveTimestamp": "1702578247021",

"ApproximateReceiveCount": "33",

"SentTimestamp": "1702578175547",

"SequenceNumber": "37329348160359135488",

"MessageDeduplicationId": "30322e496c8bd8d48d00331024899110db44a3db2ce717cdfd7dd8a4f0811acb",

"MessageGroupId": "e-CS001333807",

"AWSTraceHeader": "Root=1-657b47ff-17bb1ca77e0e9eed3cd9274d;Parent=5c6578462a250865;Sampled=0;Lineage=eac5e8ee:0",

"ClientReferenceAvailable": false,

"TransactionType": "Update"

}

},

{

"MessageId": "786c1a13-75e7-4ff1-930c-8d335f082a15",

"ReceiptHandle": "AQEBH2SQ87p2n1gBOFTyUTkiVoKjizFeZaN5XF1zVBK0vhG/XJDFlD60x0E2r+XH8XMvF5RhEDhn8eAx9NGskw3j7o5vdbreMDCWPYDWSwZGBRKKcLUYnETtD7P0MV9jUzzibUEkgH8sfz4YJH9ku9awtpVSskqsMhOx+uKNr51cjwX4z7n1r+oA08+L1A/Evgovjednr5cFzZvBP76/zIvuh7ze5/zod3KXVS5Lqo5Moximi4hbjHSAxIpn3LI3e2uZkYyi3NjXWhXFFc9ukVLQnXYS0h/jwAPsWc0C2w4b/Kw=",

"MD5OfBody": "44211efc64d16d23ba6c6779d0e04623",

"Body": {

"clientName": "Conduent Business Services Global",

"clientTicketNumber": "",

"ticketType": "Incident",

"ticketNumber": "e-CS001333807",

"updatedOn": "2023-12-14T18:22:01Z",

"notes": {

"type": "comment",

"id": "d43caaa61b0bf91426a2da49b04bcb28",

"body": "hello world comment!",

"commenter": "Joshua Jenkins",

"commenterEmail": "Joshua.Jenkins@Ensono.com"

}

},

"Attributes": {

"SenderId": "AROAYCQITFFPIEBOQI2KM:envxsn2qdev1SN2QBridge",

"ApproximateFirstReceiveTimestamp": "1702578247021",

"ApproximateReceiveCount": "33",

"SentTimestamp": "1702578176428",

"SequenceNumber": "37329348160584671488",

"MessageDeduplicationId": "385a94e0523b87b821da8a30559c6dc1ec3470f7a7acd6795d4cf0ea1ed5c613",

"MessageGroupId": "e-CS001333807",

"AWSTraceHeader": "Root=1-657b4800-5466b83324e60c4164344bcb;Parent=31936b855640dc40;Sampled=0;Lineage=eac5e8ee:0",

"ClientReferenceAvailable": false,

"TransactionType": "Notes"

}

},

{

"MessageId": "58509a36-c7fc-47c4-ac58-39a7aa1cafc9",

"ReceiptHandle": "AQEBTS9kBGdvmwEV6NAb+VJVXJPH44X3KqlpFczwCNcjVXCDt8NM+usOnSVp1BiMSkunvB3NTxqQHjpj7FYsBV1E4GKK6jXig/6Ud5ZpaODuBqmtFl2UiLrGzGYcf1v+Tpb6EDsIK/EHPUXJnbI+v7a84FYcKnyuOhT+6yWjkKAcuoUtxQ1TAy5ms/b6Xf67NofnFqkNazYm1+LLL9uzOtrquXDr5J4I9CkBxTQsM1TYIDtJoVKuORuH3LANRRzmhqPvBjCrrJ6kfK/1v/7yNv+Us9Bp048NHBDsYiZYxM0YV78=",

"MD5OfBody": "6e76cadaa034ee800b7a171f780531c4",

"Body": {

"clientName": "Conduent Business Services Global",

"clientTicketNumber": "",

"ticketType": "Incident",

"ticketNumber": "e-CS001333807",

"attachmentName": "banff.jpg",

"attachmentInfo": "https://envisiontest.service-now.com/api/now/attachment/684caa621b0bf91426a2da49b04bcb84",

"attachmentSize": "509121",

"attachmentType": "image/jpeg",

"attachment": "https://envxsn2qdev1us-west-1outbound-bucket.s3.us-west-1.amazonaws.com/banff.jpg?X-Amz-Algorithm=AW..."

},

"Attributes": {

"SenderId": "AROAYCQITFFPIEBOQI2KM:envxsn2qdev1SN2QBridge",

"ApproximateFirstReceiveTimestamp": "1702578247021",

"ApproximateReceiveCount": "33",

"SentTimestamp": "1702578195538",

"SequenceNumber": "37329348165476831232",

"MessageDeduplicationId": "c5f2047b3d5f380dabba67b4bdcf8497af00b416c6a9e7fc78a24176c9537b1e",

"MessageGroupId": "e-CS001333807",

"AWSTraceHeader": "Root=1-657b4812-0c24afbe4bbb63c908aed0d3;Parent=429d54b90ef2fde2;Sampled=0;Lineage=eac5e8ee:0",

"ClientReferenceAvailable": false,

"TransactionType": "Attachment"

}

]

}

With that out of the way here is my script step that takes the response body and attempts to place it into a usable output and each time this returns blank:

Screenshot 2023-12-18 at 11.02.44 AM.png

Here is the output variables structure I built out and I am trying to map the output to root as seen in the script above, any help here is greatly appreciated.

Screenshot 2023-12-18 at 11.03.37 AM.png

Amit Verma · ‎12-19-2023

Hi @Chad R

Have you tried using JSON Parser step instead of Script Step. It has a functionality called as "Generate Target" that could be helpful to sort out your issue.

Thanks & Regards

Amit Verma

Please mark this response as correct and helpful if it assisted you with your question.

Chad R · ‎12-19-2023

Hi Amit,

yeah the json parser step in my non production environments it works perfect, however it comes with the pro level of integration hub and I currently only have starter, which is why I'm trying to see if I can do it with the script step.

Amit Verma · ‎12-19-2023

Hi @Chad R

You can try creating output variable as shown in snips below :

Thanks & Regards

Amit Verma

Please mark this response as correct and helpful if it assisted you with your question.

Chad R · ‎12-23-2023

Thanks Amit,

Thats actually what I tried exactly how you have it mapped out but the result in the action step still shows empty. Something in my script step isn't passing the data properly not sure what as I am parsing it then converting it to an object but I believe that is where my problem lies. I appreciate your responses on this.