Returns products for vendorname = "Fabrikam".
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"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;
{
"@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"
}
]
}