Accessing oData results and applying them to field

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi All,

Quick question: I'm using oData to access some records and I have these stored as follows:

var results = JSON.parse(req.responseText).d.results;
if (results != null && results.length > 0) {
alert = whatgoeshere??
}

Can anyone reveal the syntax for accessing the results? I.e. results[0].etc.etc

Thanks a million.

PS. End goal will be to call the following:

Xrm.Page.getAttribute("new_clientalerts").setValue(alert);

*This post is locked for comments

All responses (5)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Accessing oData results and applying them to field

Guido, thanks. Bas, thanks for your suggestions.

I'm sure you'll help me again soon :)

Cheers guys
Bas van de Sande 4,383 on at

Like (1)

Report

RE: Accessing oData results and applying them to field

Hi Guido,

you're right. I overlooked the fact that Lee was using a reserved keyword..

Bas
Bas van de Sande 4,383 on at

Like (0)

Report

RE: Accessing oData results and applying them to field

Hi Lee,

can you show me how results[0] looks like?

can you also show me how alertArray looks like?

you're pretty close at this point.

Bas
Community Member Microsoft Employee on at

Like (0)

Report
RE: Accessing oData results and applying them to field

Hi Bas,

Thanks for your response. I had found the debugging technique shortly after I posted here actually but thanks for the suggestions, it will help others.

What I currently have is:

var results = JSON.parse(req.responseText).d.results; if (results != null && results.length > 0) { alertArray = results[0]; alert = alertArray.new_Alert; }

However, when I hover over the 'alert' variable, it's 'null' - I get the following:

even though the content 'alertArray.new_Alert' contains the string "test alert"

Can you shed any light on this please?

Many Thanks
Suggested answer

Bas van de Sande 4,383 on at

Like (0)

Report

RE: Accessing oData results and applying them to field

Hi Lee,

what comes behind "alert" depends on the oData source you access

If you don't know how the data looks like, a good approach is to use the javascript debugger of your browser.

Set a breakpoing on the if(results!=...) line, and see what happens if you run the script on the page.

Likely, you end up with a syntax like: alert = results.fieldname;

I hope this helps you forward

Bas