Delphi ActiveX Dynamics CRM: Get All Products for the Vendor Named "Fabrikam"

Back to Index

Returns products for vendorname = "Fabrikam".

Documentation: https://docs.microsoft.com/en-us/dynamics365/customer-engagement/web-api/incident?view=dynamics-ce-odata-9

CURL Command

curl -X GET https://my-dynamics-domain.api.crm.dynamics.com/api/data/v9.0/products \
  -H "Accept: application/json" \
  -H "OData-MaxVersion: 4.0"  \
  -H "OData-Version: 4.0" \
  -d "$select=name,description,productid,productnumber,quantitydecimal,vendorpartnumber,price,vendorname,standardcost,quantityonhand" \
  -d "$filter=vendorname eq 'Fabrikam'" \
  -H "Authorization: Bearer DYNAMICS_CRM_ACCESS_TOKEN"

Delphi ActiveX Example

var
rest: TChilkatRest;
success: Integer;
bTls: Integer;
port: Integer;
bAutoReconnect: Integer;
sbResponseBody: TChilkatStringBuilder;
respStatusCode: Integer;
jsonResponse: TChilkatJsonObject;
i: Integer;
count_i: Integer;
odataContext: WideString;
odataEtag: WideString;
name: WideString;
description: WideString;
productid: WideString;
productnumber: WideString;
quantitydecimal: Integer;
vendorpartnumber: WideString;
price: Integer;
vendorname: WideString;
standardcost: Integer;
quantityonhand: Integer;
v_transactioncurrencyid_value: WideString;

begin
rest := TChilkatRest.Create(Self);

//  URL: https://my-dynamics-domain.api.crm.dynamics.com/api/data/v9.0/products
bTls := 1;
port := 443;
bAutoReconnect := 1;
success := rest.Connect('my-dynamics-domain.api.crm.dynamics.com',port,bTls,bAutoReconnect);
if (success <> 1) then
  begin
    Memo1.Lines.Add('ConnectFailReason: ' + IntToStr(rest.ConnectFailReason));
    Memo1.Lines.Add(rest.LastErrorText);
    Exit;
  end;

rest.AddQueryParam('$select','name,description,productid,productnumber,quantitydecimal,vendorpartnumber,price,vendorname,standardcost,quantityonhand');
rest.AddQueryParam('$filter','vendorname eq ''Fabrikam''');

rest.AddHeader('OData-MaxVersion','4.0');
rest.AddHeader('Accept','application/json');
rest.AddHeader('OData-Version','4.0');
rest.AddHeader('Authorization','Bearer DYNAMICS_CRM_ACCESS_TOKEN');

sbResponseBody := TChilkatStringBuilder.Create(Self);
success := rest.FullRequestNoBodySb('GET','/api/data/v9.0/products',sbResponseBody.ControlInterface);
if (success <> 1) then
  begin
    Memo1.Lines.Add(rest.LastErrorText);
    Exit;
  end;
respStatusCode := rest.ResponseStatusCode;
if (respStatusCode >= 400) then
  begin
    Memo1.Lines.Add('Response Status Code = ' + IntToStr(respStatusCode));
    Memo1.Lines.Add('Response Header:');
    Memo1.Lines.Add(rest.ResponseHeader);
    Memo1.Lines.Add('Response Body:');
    Memo1.Lines.Add(sbResponseBody.GetAsString());
    Exit;
  end;

jsonResponse := TChilkatJsonObject.Create(Self);
jsonResponse.LoadSb(sbResponseBody.ControlInterface);

odataContext := jsonResponse.StringOf('"@odata.context"');
i := 0;
count_i := jsonResponse.SizeOfArray('value');
while i < count_i do
  begin
    jsonResponse.I := i;
    odataEtag := jsonResponse.StringOf('value[i]."@odata.etag"');
    name := jsonResponse.StringOf('value[i].name');
    description := jsonResponse.StringOf('value[i].description');
    productid := jsonResponse.StringOf('value[i].productid');
    productnumber := jsonResponse.StringOf('value[i].productnumber');
    quantitydecimal := jsonResponse.IntOf('value[i].quantitydecimal');
    vendorpartnumber := jsonResponse.StringOf('value[i].vendorpartnumber');
    price := jsonResponse.IntOf('value[i].price');
    vendorname := jsonResponse.StringOf('value[i].vendorname');
    standardcost := jsonResponse.IntOf('value[i].standardcost');
    quantityonhand := jsonResponse.IntOf('value[i].quantityonhand');
    v_transactioncurrencyid_value := jsonResponse.StringOf('value[i]._transactioncurrencyid_value');
    i := i + 1;
  end;

Sample JSON Response Body

{
  "@odata.context": "https://mydomain.api.crm.dynamics.com/api/data/v9.0/$metadata#products(name,description,productid,productnumber,quantitydecimal,vendorpartnumber,price,vendorname,standardcost,quantityonhand)",
  "value": [
    {
      "@odata.etag": "W/\"1164515\"",
      "name": "Fabrikam E080",
      "description": "Fabrikam Coffee Maker 4C E080 White",
      "productid": "bfc1dbad-91df-e311-b8e5-6c3be5a8b200",
      "productnumber": "218100-E080-WHI",
      "quantitydecimal": 2,
      "vendorpartnumber": "E080",
      "price": 129.9000,
      "vendorname": "Fabrikam",
      "standardcost": 66.2300,
      "quantityonhand": 489.0000000000,
      "_transactioncurrencyid_value": "f92b569a-d61e-e811-a980-000d3a192e9a"
    },
    {
      "@odata.etag": "W/\"1164518\"",
      "name": "Fabrikam E0800",
      "description": "Fabrikam Microwave 0.8CuFt E0800 Black",
      "productid": "c1c1dbad-91df-e311-b8e5-6c3be5a8b200",
      "productnumber": "201200-E0800-BLA",
      "quantitydecimal": 2,
      "vendorpartnumber": "E0800",
      "price": 94.9900,
      "vendorname": "Fabrikam",
      "standardcost": 48.4300,
      "quantityonhand": 1125.0000000000,
      "_transactioncurrencyid_value": "f92b569a-d61e-e811-a980-000d3a192e9a"
    },
    {
      "@odata.etag": "W/\"1164521\"",
      "name": "Fabrikam E090",
      "description": "Fabrikam Coffee Maker Auto 5C E090 Silver",
      "productid": "c3c1dbad-91df-e311-b8e5-6c3be5a8b200",
      "productnumber": "217300-E090-SIL",
      "quantitydecimal": 2,
      "vendorpartnumber": "E090",
      "price": 163.0000,
      "vendorname": "Fabrikam",
      "standardcost": 83.1000,
      "quantityonhand": 755.0000000000,
      "_transactioncurrencyid_value": "f92b569a-d61e-e811-a980-000d3a192e9a"
    },
    {
      "@odata.etag": "W/\"1164524\"",
      "name": "Fabrikam E0900",
      "description": "Fabrikam Microwave 0.9CuFt E0900 Red",
      "productid": "c5c1dbad-91df-e311-b8e5-6c3be5a8b200",
      "productnumber": "200500-E0900-RED",
      "quantitydecimal": 2,
      "vendorpartnumber": "E0900",
      "price": 99.9900,
      "vendorname": "Fabrikam",
      "standardcost": 50.9800,
      "quantityonhand": 1181.0000000000,
      "_transactioncurrencyid_value": "f92b569a-d61e-e811-a980-000d3a192e9a"
    },
    {
      "@odata.etag": "W/\"1164527\"",
      "name": "Fabrikam E100",
      "description": "Fabrikam Social Videographer 2/3\" 17mm E100 Orange",
      "productid": "c7c1dbad-91df-e311-b8e5-6c3be5a8b200",
      "productnumber": "119100-E100-ORA",
      "quantitydecimal": 2,
      "vendorpartnumber": "E100",
      "price": 160.0000,
      "vendorname": "Fabrikam",
      "standardcost": 81.5700,
      "quantityonhand": 130.0000000000,
      "_transactioncurrencyid_value": "f92b569a-d61e-e811-a980-000d3a192e9a"
    },
    {
      "@odata.etag": "W/\"1164532\"",
      "name": "Fabrikam E1100",
      "description": "Fabrikam Microwave 1.0CuFt E1100 Silver",
      "productid": "c9c1dbad-91df-e311-b8e5-6c3be5a8b200",
      "productnumber": "199200-E1100-SIL",
      "quantitydecimal": 2,
      "vendorpartnumber": "E1100",
      "price": 139.9900,
      "vendorname": "Fabrikam",
      "standardcost": 71.3700,
      "quantityonhand": 1267.0000000000,
      "_transactioncurrencyid_value": "f92b569a-d61e-e811-a980-000d3a192e9a"
    },
    {
      "@odata.etag": "W/\"1164535\"",
      "name": "Fabrikam E1200",
      "description": "Fabrikam Refrigerator 1.7CuFt E1200 Brown",
      "productid": "cbc1dbad-91df-e311-b8e5-6c3be5a8b200",
      "productnumber": "190800-E1200-BRO",
      "quantitydecimal": 2,
      "vendorpartnumber": "E1200",
      "price": 129.9900,
      "vendorname": "Fabrikam",
      "standardcost": 66.2700,
      "quantityonhand": 902.0000000000,
      "_transactioncurrencyid_value": "f92b569a-d61e-e811-a980-000d3a192e9a"
    },
    {
      "@odata.etag": "W/\"1164538\"",
      "name": "Fabrikam E1600",
      "description": "Fabrikam Refrigerator 3.2CuFt E1600 Blue",
      "productid": "cdc1dbad-91df-e311-b8e5-6c3be5a8b200",
      "productnumber": "192500-E1600-BLU",
      "quantitydecimal": 2,
      "vendorpartnumber": "E1600",
      "price": 279.9900,
      "vendorname": "Fabrikam",
      "standardcost": 142.7500,
      "quantityonhand": 882.0000000000,
      "_transactioncurrencyid_value": "f92b569a-d61e-e811-a980-000d3a192e9a"
    },
    {
      "@odata.etag": "W/\"1164541\"",
      "name": "Fabrikam E200",
      "description": "Fabrikam Budget Moviemaker 1/3'' 8.5mm E200 White",
      "productid": "cfc1dbad-91df-e311-b8e5-6c3be5a8b200",
      "productnumber": "117400-E200-WHI",
      "quantitydecimal": 2,
      "vendorpartnumber": "E200",
      "price": 411.0000,
      "vendorname": "Fabrikam",
      "standardcost": 209.5400,
      "quantityonhand": 709.0000000000,
      "_transactioncurrencyid_value": "f92b569a-d61e-e811-a980-000d3a192e9a"
    },
    {
      "@odata.etag": "W/\"1164545\"",
      "name": "Fabrikam E2800",
      "description": "Fabrikam Refrigerator 4.6CuFt E2800 Brown",
      "productid": "d1c1dbad-91df-e311-b8e5-6c3be5a8b200",
      "productnumber": "190600-E2800-BRO",
      "quantitydecimal": 2,
      "vendorpartnumber": "E2800",
      "price": 299.9900,
      "vendorname": "Fabrikam",
      "standardcost": 152.9400,
      "quantityonhand": 1132.0000000000,
      "_transactioncurrencyid_value": "f92b569a-d61e-e811-a980-000d3a192e9a"
    },
    {
      "@odata.etag": "W/\"1164550\"",
      "name": "Fabrikam E300",
      "description": "Fabrikam Budget Moviemaker 1/2'' 3mm E300 Grey",
      "productid": "d3c1dbad-91df-e311-b8e5-6c3be5a8b200",
      "productnumber": "119700-E300-GRE",
      "quantitydecimal": 2,
      "vendorpartnumber": "E300",
      "price": 432.0000,
      "vendorname": "Fabrikam",
      "standardcost": 220.2500,
      "quantityonhand": 1406.0000000000,
      "_transactioncurrencyid_value": "f92b569a-d61e-e811-a980-000d3a192e9a"
    },
    {
      "@odata.etag": "W/\"1164553\"",
      "name": "Fabrikam E400",
      "description": "Fabrikam Budget Moviemaker 1'' 25mm E400 Black",
      "productid": "d5c1dbad-91df-e311-b8e5-6c3be5a8b200",
      "productnumber": "122000-E400-BLA",
      "quantitydecimal": 2,
      "vendorpartnumber": "E400",
      "price": 452.0000,
      "vendorname": "Fabrikam",
      "standardcost": 230.4400,
      "quantityonhand": 582.0000000000,
      "_transactioncurrencyid_value": "f92b569a-d61e-e811-a980-000d3a192e9a"
    },
    {
      "@odata.etag": "W/\"1164556\"",
      "name": "Fabrikam E4101",
      "description": "Fabrikam Laptop14.1 E4101 Red",
      "productid": "d7c1dbad-91df-e311-b8e5-6c3be5a8b200",
      "productnumber": "357000-E4101-RED",
      "quantitydecimal": 2,
      "vendorpartnumber": "E4101",
      "price": 330.0000,
      "vendorname": "Fabrikam",
      "standardcost": 168.2400,
      "quantityonhand": 1291.0000000000,
      "_transactioncurrencyid_value": "f92b569a-d61e-e811-a980-000d3a192e9a"
    },
    {
      "@odata.etag": "W/\"1164559\"",
      "name": "Fabrikam M0100",
      "description": "Fabrikam Laptop10.1 M0100 White",
      "productid": "d9c1dbad-91df-e311-b8e5-6c3be5a8b200",
      "productnumber": "349000-M0100-WHI",
      "quantitydecimal": 2,
      "vendorpartnumber": "M0100",
      "price": 383.0000,
      "vendorname": "Fabrikam",
      "standardcost": 195.2600,
      "quantityonhand": 783.0000000000,
      "_transactioncurrencyid_value": "f92b569a-d61e-e811-a980-000d3a192e9a"
    },
    {
      "@odata.etag": "W/\"1164562\"",
      "name": "Fabrikam M100",
      "description": "Fabrikam Coffee Maker Auto 10C M100 Silver",
      "productid": "dbc1dbad-91df-e311-b8e5-6c3be5a8b200",
      "productnumber": "217100-M100-SIL",
      "quantitydecimal": 2,
      "vendorpartnumber": "M100",
      "price": 745.9900,
      "vendorname": "Fabrikam",
      "standardcost": 343.0500,
      "quantityonhand": 1585.0000000000,
      "_transactioncurrencyid_value": "f92b569a-d61e-e811-a980-000d3a192e9a"
    },
    {
      "@odata.etag": "W/\"1164567\"",
      "name": "Fabrikam M100",
      "description": "Fabrikam Coffee Maker 12C M100 Gold",
      "productid": "ddc1dbad-91df-e311-b8e5-6c3be5a8b200",
      "productnumber": "218800-M100-GOL",
      "quantitydecimal": 2,
      "vendorpartnumber": "M100",
      "price": 445.0000,
      "vendorname": "Fabrikam",
      "standardcost": 204.6400,
      "quantityonhand": 1522.0000000000,
      "_transactioncurrencyid_value": "f92b569a-d61e-e811-a980-000d3a192e9a"
    },
    {
      "@odata.etag": "W/\"1164570\"",
      "name": "Fabrikam M1250",
      "description": "Fabrikam Microwave 1.6CuFt M1250 White",
      "productid": "dfc1dbad-91df-e311-b8e5-6c3be5a8b200",
      "productnumber": "198500-M1250-WHI",
      "quantitydecimal": 2,
      "vendorpartnumber": "M1250",
      "price": 179.9900,
      "vendorname": "Fabrikam",
      "standardcost": 82.7700,
      "quantityonhand": 663.0000000000,
      "_transactioncurrencyid_value": "f92b569a-d61e-e811-a980-000d3a192e9a"
    },
    {
      "@odata.etag": "W/\"1164573\"",
      "name": "Fabrikam M1250",
      "description": "Fabrikam Microwave 2.2CuFt M1250 Black",
      "productid": "e1c1dbad-91df-e311-b8e5-6c3be5a8b200",
      "productnumber": "200800-M1250-BLA",
      "quantitydecimal": 2,
      "vendorpartnumber": "M1250",
      "price": 199.9900,
      "vendorname": "Fabrikam",
      "standardcost": 91.9700,
      "quantityonhand": 1504.0000000000,
      "_transactioncurrencyid_value": "f92b569a-d61e-e811-a980-000d3a192e9a"
    },
    {
      "@odata.etag": "W/\"1164576\"",
      "name": "Fabrikam M147",
      "description": "Fabrikam SLR Camera M147 Grey",
      "productid": "e3c1dbad-91df-e311-b8e5-6c3be5a8b200",
      "productnumber": "111800-M147-GRE",
      "quantitydecimal": 2,
      "vendorpartnumber": "M147",
      "price": 334.0000,
      "vendorname": "Fabrikam",
      "standardcost": 153.5900,
      "quantityonhand": 647.0000000000,
      "_transactioncurrencyid_value": "f92b569a-d61e-e811-a980-000d3a192e9a"
    },
    {
      "@odata.etag": "W/\"1164579\"",
      "name": "Fabrikam M149",
      "description": "Fabrikam SLR Camera M149 Pink",
      "productid": "e5c1dbad-91df-e311-b8e5-6c3be5a8b200",
      "productnumber": "113000-M149-PIN",
      "quantitydecimal": 2,
      "vendorpartnumber": "M149",
      "price": 319.0000,
      "vendorname": "Fabrikam",
      "standardcost": 146.7000,
      "quantityonhand": 465.0000000000,
      "_transactioncurrencyid_value": "f92b569a-d61e-e811-a980-000d3a192e9a"
    },
    {
      "@odata.etag": "W/\"1164584\"",
      "name": "Fabrikam M200",
      "description": "Fabrikam Home and vacation moviemaker 1/3\" 8.5mm M200 Blue",
      "productid": "e7c1dbad-91df-e311-b8e5-6c3be5a8b200",
      "productnumber": "114600-M200-BLU",
      "quantitydecimal": 2,
      "vendorpartnumber": "M200",
      "price": 633.0000,
      "vendorname": "Fabrikam",
      "standardcost": 291.0900,
      "quantityonhand": 448.0000000000,
      "_transactioncurrencyid_value": "f92b569a-d61e-e811-a980-000d3a192e9a"
    },
    {
      "@odata.etag": "W/\"1164587\"",
      "name": "Fabrikam M2000",
      "description": "Fabrikam Laptop12 M2000 White",
      "productid": "e9c1dbad-91df-e311-b8e5-6c3be5a8b200",
      "productnumber": "344000-M2000-WHI",
      "quantitydecimal": 2,
      "vendorpartnumber": "M2000",
      "price": 366.0000,
      "vendorname": "Fabrikam",
      "standardcost": 186.6000,
      "quantityonhand": 110.0000000000,
      "_transactioncurrencyid_value": "f92b569a-d61e-e811-a980-000d3a192e9a"
    },
    {
      "@odata.etag": "W/\"1164590\"",
      "name": "Fabrikam M280",
      "description": "Fabrikam Business Videographer 2/3'' 17mm M280 Grey",
      "productid": "ebc1dbad-91df-e311-b8e5-6c3be5a8b200",
      "productnumber": "121100-M280-GRE",
      "quantitydecimal": 2,
      "vendorpartnumber": "M280",
      "price": 850.0000,
      "vendorname": "Fabrikam",
      "standardcost": 390.8800,
      "quantityonhand": 467.0000000000,
      "_transactioncurrencyid_value": "f92b569a-d61e-e811-a980-000d3a192e9a"
    },
    {
      "@odata.etag": "W/\"1164593\"",
      "name": "Fabrikam M358",
      "description": "Fabrikam SLR Camera 35\" M358 Silver",
      "productid": "edc1dbad-91df-e311-b8e5-6c3be5a8b200",
      "productnumber": "111500-M358-SIL",
      "quantitydecimal": 2,
      "vendorpartnumber": "M358",
      "price": 328.0000,
      "vendorname": "Fabrikam",
      "standardcost": 150.8400,
      "quantityonhand": 731.0000000000,
      "_transactioncurrencyid_value": "f92b569a-d61e-e811-a980-000d3a192e9a"
    },
    {
      "@odata.etag": "W/\"1164596\"",
      "name": "Fabrikam M380",
      "description": "Fabrikam Business Videographer 1/3'' 8.5mm M380 Black",
      "productid": "efc1dbad-91df-e311-b8e5-6c3be5a8b200",
      "productnumber": "116200-M380-BLA",
      "quantitydecimal": 2,
      "vendorpartnumber": "M380",
      "price": 860.0000,
      "vendorname": "Fabrikam",
      "standardcost": 395.4800,
      "quantityonhand": 500.0000000000,
      "_transactioncurrencyid_value": "f92b569a-d61e-e811-a980-000d3a192e9a"
    },
    {
      "@odata.etag": "W/\"1164599\"",
      "name": "Fabrikam M400",
      "description": "Fabrikam Home and Vacation Moviemaker 1\" 25mm M400 Blue",
      "productid": "f1c1dbad-91df-e311-b8e5-6c3be5a8b200",
      "productnumber": "114400-M400-BLU",
      "quantitydecimal": 2,
      "vendorpartnumber": "M400",
      "price": 600.0000,
      "vendorname": "Fabrikam",
      "standardcost": 275.9200,
      "quantityonhand": 1000.0000000000,
      "_transactioncurrencyid_value": "f92b569a-d61e-e811-a980-000d3a192e9a"
    },
    {
      "@odata.etag": "W/\"1164602\"",
      "name": "Fabrikam M4100",
      "description": "Fabrikam Laptop14.1 M4100 White",
      "productid": "f3c1dbad-91df-e311-b8e5-6c3be5a8b200",
      "productnumber": "347000-M4100-WHI",
      "quantitydecimal": 2,
      "vendorpartnumber": "M4100",
      "price": 586.0000,
      "vendorname": "Fabrikam",
      "standardcost": 269.4800,
      "quantityonhand": 1627.0000000000,
      "_transactioncurrencyid_value": "f92b569a-d61e-e811-a980-000d3a192e9a"
    },
    {
      "@odata.etag": "W/\"1164607\"",
      "name": "Fabrikam M4180",
      "description": "Fabrikam Laptop14.1W M4180 Red",
      "productid": "f5c1dbad-91df-e311-b8e5-6c3be5a8b200",
      "productnumber": "356000-M4180-RED",
      "quantitydecimal": 2,
      "vendorpartnumber": "M4180",
      "price": 456.9000,
      "vendorname": "Fabrikam",
      "standardcost": 210.1100,
      "quantityonhand": 1146.0000000000,
      "_transactioncurrencyid_value": "f92b569a-d61e-e811-a980-000d3a192e9a"
    },
    {
      "@odata.etag": "W/\"1164610\"",
      "name": "Fabrikam M500",
      "description": "Fabrikam Business Videographer 1/2\" 3mm M500 Orange",
      "productid": "f7c1dbad-91df-e311-b8e5-6c3be5a8b200",
      "productnumber": "118500-M500-ORA",
      "quantitydecimal": 2,
      "vendorpartnumber": "M500",
      "price": 880.0000,
      "vendorname": "Fabrikam",
      "standardcost": 404.6800,
      "quantityonhand": 236.0000000000,
      "_transactioncurrencyid_value": "f92b569a-d61e-e811-a980-000d3a192e9a"
    },
    {
      "@odata.etag": "W/\"1164613\"",
      "name": "Fabrikam M5400",
      "description": "Fabrikam Laptop15.4 M5400 White",
      "productid": "f9c1dbad-91df-e311-b8e5-6c3be5a8b200",
      "productnumber": "346000-M5400-WHI",
      "quantitydecimal": 2,
      "vendorpartnumber": "M5400",
      "price": 659.0000,
      "vendorname": "Fabrikam",
      "standardcost": 303.0500,
      "quantityonhand": 1700.0000000000,
      "_transactioncurrencyid_value": "f92b569a-d61e-e811-a980-000d3a192e9a"
    },
    {
      "@odata.etag": "W/\"1164616\"",
      "name": "Fabrikam M5600",
      "description": "Fabrikam Refrigerator 9.7CuFt M5600 Green",
      "productid": "fbc1dbad-91df-e311-b8e5-6c3be5a8b200",
      "productnumber": "191700-M5600-GRE",
      "quantitydecimal": 2,
      "vendorpartnumber": "M5600",
      "price": 493.0000,
      "vendorname": "Fabrikam",
      "standardcost": 226.7100,
      "quantityonhand": 1511.0000000000,
      "_transactioncurrencyid_value": "f92b569a-d61e-e811-a980-000d3a192e9a"
    },
    {
      "@odata.etag": "W/\"1164619\"",
      "name": "Fabrikam M600",
      "description": "Fabrikam Business Videographer 1'' 25mm M600 White",
      "productid": "fdc1dbad-91df-e311-b8e5-6c3be5a8b200",
      "productnumber": "118400-M600-WHI",
      "quantitydecimal": 2,
      "vendorpartnumber": "M600",
      "price": 890.0000,
      "vendorname": "Fabrikam",
      "standardcost": 409.2800,
      "quantityonhand": 1639.0000000000,
      "_transactioncurrencyid_value": "f92b569a-d61e-e811-a980-000d3a192e9a"
    },
    {
      "@odata.etag": "W/\"1164622\"",
      "name": "Fabrikam M6080",
      "description": "Fabrikam Laptop16W M6080 Black",
      "productid": "ffc1dbad-91df-e311-b8e5-6c3be5a8b200",
      "productnumber": "341000-M6080-BLA",
      "quantitydecimal": 2,
      "vendorpartnumber": "M6080",
      "price": 967.0000,
      "vendorname": "Fabrikam",
      "standardcost": 444.6900,
      "quantityonhand": 1188.0000000000,
      "_transactioncurrencyid_value": "f92b569a-d61e-e811-a980-000d3a192e9a"
    },
    {
      "@odata.etag": "W/\"1164625\"",
      "name": "Fabrikam M7600",
      "description": "Fabrikam Refrigerator 19CuFt M7600 White",
      "productid": "01c2dbad-91df-e311-b8e5-6c3be5a8b200",
      "productnumber": "189800-M7600-WHI",
      "quantitydecimal": 2,
      "vendorpartnumber": "M7600",
      "price": 899.0000,
      "vendorname": "Fabrikam",
      "standardcost": 413.4200,
      "quantityonhand": 1667.0000000000,
      "_transactioncurrencyid_value": "f92b569a-d61e-e811-a980-000d3a192e9a"
    },
    {
      "@odata.etag": "W/\"1164629\"",
      "name": "Fabrikam M9000",
      "description": "Fabrikam Laptop19 M9000 Black",
      "productid": "03c2dbad-91df-e311-b8e5-6c3be5a8b200",
      "productnumber": "343000-M9000-BLA",
      "quantitydecimal": 2,
      "vendorpartnumber": "M9000",
      "price": 1099.0000,
      "vendorname": "Fabrikam",
      "standardcost": 364.1200,
      "quantityonhand": 1153.0000000000,
      "_transactioncurrencyid_value": "f92b569a-d61e-e811-a980-000d3a192e9a"
    },
    {
      "@odata.etag": "W/\"1164632\"",
      "name": "Fabrikam M9800",
      "description": "Fabrikam Laptop19W M9800 Black",
      "productid": "05c2dbad-91df-e311-b8e5-6c3be5a8b200",
      "productnumber": "338000-M9800-BLA",
      "quantitydecimal": 2,
      "vendorpartnumber": "M9800",
      "price": 1199.0000,
      "vendorname": "Fabrikam",
      "standardcost": 397.2500,
      "quantityonhand": 1581.0000000000,
      "_transactioncurrencyid_value": "f92b569a-d61e-e811-a980-000d3a192e9a"
    },
    {
      "@odata.etag": "W/\"1164636\"",
      "name": "Fabrikam X100",
      "description": "Fabrikam Independent Filmmaker 2/3\" 17mm X100 Blue",
      "productid": "07c2dbad-91df-e311-b8e5-6c3be5a8b200",
      "productnumber": "115900-X100-BLU",
      "quantitydecimal": 2,
      "vendorpartnumber": "X100",
      "price": 1520.0000,
      "vendorname": "Fabrikam",
      "standardcost": 503.6100,
      "quantityonhand": 574.0000000000,
      "_transactioncurrencyid_value": "f92b569a-d61e-e811-a980-000d3a192e9a"
    },
    {
      "@odata.etag": "W/\"1164639\"",
      "name": "Fabrikam X1100",
      "description": "Fabrikam Microwave 1.5CuFt X1100 Red",
      "productid": "09c2dbad-91df-e311-b8e5-6c3be5a8b200",
      "productnumber": "200100-X1100-RED",
      "quantitydecimal": 2,
      "vendorpartnumber": "X1100",
      "price": 665.9400,
      "vendorname": "Fabrikam",
      "standardcost": 220.6400,
      "quantityonhand": 324.0000000000,
      "_transactioncurrencyid_value": "f92b569a-d61e-e811-a980-000d3a192e9a"
    },
    {
      "@odata.etag": "W/\"1164642\"",
      "name": "Fabrikam X125",
      "description": "Fabrikam Coffee Maker Super-Auto 12C X125 White",
      "productid": "0bc2dbad-91df-e311-b8e5-6c3be5a8b200",
      "productnumber": "217600-X125-WHI",
      "quantitydecimal": 2,
      "vendorpartnumber": "X125",
      "price": 1650.0000,
      "vendorname": "Fabrikam",
      "standardcost": 546.6800,
      "quantityonhand": 254.0000000000,
      "_transactioncurrencyid_value": "f92b569a-d61e-e811-a980-000d3a192e9a"
    },
    {
      "@odata.etag": "W/\"1164645\"",
      "name": "Fabrikam X200",
      "description": "Fabrikam Trendsetter 1/3'' 8.5mm X200 White",
      "productid": "0dc2dbad-91df-e311-b8e5-6c3be5a8b200",
      "productnumber": "117800-X200-WHI",
      "quantitydecimal": 2,
      "vendorpartnumber": "X200",
      "price": 998.0000,
      "vendorname": "Fabrikam",
      "standardcost": 330.6600,
      "quantityonhand": 692.0000000000,
      "_transactioncurrencyid_value": "f92b569a-d61e-e811-a980-000d3a192e9a"
    },
    {
      "@odata.etag": "W/\"1164648\"",
      "name": "Fabrikam X300",
      "description": "Fabrikam Independent Filmmaker 1/2'' 3mm X300 Grey",
      "productid": "0fc2dbad-91df-e311-b8e5-6c3be5a8b200",
      "productnumber": "120500-X300-GRE",
      "quantitydecimal": 2,
      "vendorpartnumber": "X300",
      "price": 1580.0000,
      "vendorname": "Fabrikam",
      "standardcost": 523.4900,
      "quantityonhand": 177.0000000000,
      "_transactioncurrencyid_value": "f92b569a-d61e-e811-a980-000d3a192e9a"
    },
    {
      "@odata.etag": "W/\"1164651\"",
      "name": "Fabrikam X358",
      "description": "Fabrikam SLR Camera 35\" X358 Gold",
      "productid": "11c2dbad-91df-e311-b8e5-6c3be5a8b200",
      "productnumber": "112500-X358-GOL",
      "quantitydecimal": 2,
      "vendorpartnumber": "X358",
      "price": 436.2000,
      "vendorname": "Fabrikam",
      "standardcost": 144.5200,
      "quantityonhand": 1253.0000000000,
      "_transactioncurrencyid_value": "f92b569a-d61e-e811-a980-000d3a192e9a"
    },
    {
      "@odata.etag": "W/\"1164656\"",
      "name": "Fabrikam X400",
      "description": "Fabrikam Trendsetter 1'' 25mm X400 Black",
      "productid": "13c2dbad-91df-e311-b8e5-6c3be5a8b200",
      "productnumber": "122400-X400-BLA",
      "quantitydecimal": 2,
      "vendorpartnumber": "X400",
      "price": 1030.0000,
      "vendorname": "Fabrikam",
      "standardcost": 341.2600,
      "quantityonhand": 1272.0000000000,
      "_transactioncurrencyid_value": "f92b569a-d61e-e811-a980-000d3a192e9a"
    },
    {
      "@odata.etag": "W/\"1164659\"",
      "name": "Fabrikam X9800",
      "description": "Fabrikam Refrigerator 24.7CuFt X9800 Silver",
      "productid": "15c2dbad-91df-e311-b8e5-6c3be5a8b200",
      "productnumber": "190900-X9800-SIL",
      "quantitydecimal": 2,
      "vendorpartnumber": "X9800",
      "price": 3199.9900,
      "vendorname": "Fabrikam",
      "standardcost": 1060.2200,
      "quantityonhand": 718.0000000000,
      "_transactioncurrencyid_value": "f92b569a-d61e-e811-a980-000d3a192e9a"
    }
  ]
}