Dynamics Community Forum Thread Details

Querying metadata and data values

Hello there,

I'm starting learning CRM through an intership and currently working on an solution in which I will show some statistics in a Iframe with a webpage.

For such, i'm querying the CRM with the sdk web api (javascript - MSCRM Solution), and for this example i will use generic fields for better understanding:

WebApi.retrieveRecord(VinID, "accounts", "accountnumber,name,telephone1", null,
function (result) {
OppRecords = result;
},
function (error) {
alert("[Could not get the data] - Error Message : " + error.message);
},
false, null
);

Here are 2 examples of the json:

- @odata.etag:"W/"1079634"",
- accountnumber:"AF3HN2S4",
- name:"A. Datum",
- telephone1:"+86-23-4444-0100",
- accountid:"475b158c-541c-e511-80d3-3863bb347ba8"
},
{
- @odata.etag:"W/"1007819"",
- accountnumber:"ABSS4G45",
- name:"Adventure Works",
- telephone1:"+27-264-1234567",
- accountid:"a8a19cdd-88df-e311-b8e5-6c3be5a8b200"
  
  Is there any way to query the metadata (the display name, the type of the fields) in the same query and have them in the corresponding object of the json received? If so, how will i query it?
  
  Or will i have to do two different queries and then try to put everything together?
  
  Thank you very much for your patience!