Getting Usable data from deserialized JSON data using ColdFusion

Question

I have successfully deserialized my JSON data into a structure, however, it appears to be a multilayered structure with an array inside of it. How do I get the data where the arrows are in the image into a usable variable?

I have already tried several ways to try and get the data but get various error messages. Our current solution isn't multi-layered like this so this type of variable works, but not with this new response.

The image is dumping this variable:

<cfset responseStruct = deserializeJSON(response.Filecontent)>

Is your tenders array always 1 or more than 1 or some is empty ? — Kannan.P
– Kannan.P, Commented May 9, 2019 at 14:26

James A Mohler · Accepted Answer · 2019-05-09 14:45:42Z

4

Looks like you need to

responseStruct.transaction.tenders[1].amount_money.amount;
responseStruct.transaction.tenders[1].card_details.card.card_brand;
responseStruct.transaction.tenders[1].card_details.card.last_4;
responseStruct.transaction.tenders[1].card_details.status;
responseStruct.transaction.tenders[1].transaction_id;

answered May 9, 2019 at 14:45

James A Mohler

11.1k15 gold badges51 silver badges76 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

David Jacobson Over a year ago

James, I swear I tried this and it didn't work. I must have done something slightly different but this WORKS! Thx.

Collectives™ on Stack Overflow

Getting Usable data from deserialized JSON data using ColdFusion

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related