How do I parse OData response?

(0) Share

Report

Posted on by Abdul Wahab

12,070 Super User 2024 Season 1

Hi all

I have this data response:

"{
"d" : {
"results": [
{
"__metadata": {
"uri": "http://win-bd86268lvbk/CRMDEVELOPMENT/XRMServices/2011/OrganizationData.svc/BusinessUnitSet(guid'69e04798-1576-e611-80e4-308d99276d29')", "type": "Microsoft.Crm.Sdk.Data.Services.BusinessUnit"
}, "Address1_StateOrProvince": "Sindh", "Address1_Line1": "Gulshan e Iqbal", "Address1_City": "Karachi", "BusinessUnitId": "69e04798-15768d99276d29", "Address1_PostalCode": "75300", "Address1_Country": "Pakistan"
}
]
}
}"

How do parse it using JavaScript.?

I tried these options but fail to get values:

var retrieved = JSON.parse(req.responseText).d,
retrievedRecord = retrieved.results.Address1_Line1,
City = retrieved.results[0].Address1_City,
Country = retrieved.results[1].Address1_Country;

Only the highlighted one is working which gives me the above response.

Thank You

*This post is locked for comments

All responses (2)

Answers (2)

Verified answer

a33ik 84,323 Most Valuable Professional on at

Like (1)

Report

RE: How do I parse OData response?

var City = retrieved.results[0].Address1_City;

This syntax should work.
Verified answer

jlattimer 24,558 on at

Like (1)

Report
RE: How do I parse OData response?

If you've queried multiple records, it would look something like this:

var returned = JSON.parse(this.responseText).d; var results = returned.results; for (var i = 0; i < results.length; i++) { var address1_City = results[i].Address1_City; var address1_Line1 = results[i].Address1_Line1; var name = results[i].Name; }