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"Use ChilkatAx-9.5.0-win32.pkg
Procedure Test
Handle hoRest
Boolean iSuccess
Boolean iBTls
Integer iPort
Boolean iBAutoReconnect
Variant vSbResponseBody
Handle hoSbResponseBody
Integer iRespStatusCode
Handle hoJsonResponse
Integer i
Integer iCount_i
String sOdataContext
String sOdataEtag
String sName
String sDescription
String sProductid
String sProductnumber
Integer iQuantitydecimal
String sVendorpartnumber
Integer iPrice
String sVendorname
Integer iStandardcost
Integer iQuantityonhand
String sV_transactioncurrencyid_value
String sTemp1
Integer iTemp1
Get Create (RefClass(cComChilkatRest)) To hoRest
If (Not(IsComObjectCreated(hoRest))) Begin
Send CreateComObject of hoRest
End
// URL: https://my-dynamics-domain.api.crm.dynamics.com/api/data/v9.0/products
Move True To iBTls
Move 443 To iPort
Move True To iBAutoReconnect
Get ComConnect Of hoRest "my-dynamics-domain.api.crm.dynamics.com" iPort iBTls iBAutoReconnect To iSuccess
If (iSuccess <> True) Begin
Get ComConnectFailReason Of hoRest To iTemp1
Showln "ConnectFailReason: " iTemp1
Get ComLastErrorText Of hoRest To sTemp1
Showln sTemp1
Procedure_Return
End
Get ComAddQueryParam Of hoRest "$select" "name,description,productid,productnumber,quantitydecimal,vendorpartnumber,price,vendorname,standardcost,quantityonhand" To iSuccess
Get ComAddQueryParam Of hoRest "$filter" "vendorname eq 'Fabrikam'" To iSuccess
Get ComAddHeader Of hoRest "OData-MaxVersion" "4.0" To iSuccess
Get ComAddHeader Of hoRest "Accept" "application/json" To iSuccess
Get ComAddHeader Of hoRest "OData-Version" "4.0" To iSuccess
Get ComAddHeader Of hoRest "Authorization" "Bearer DYNAMICS_CRM_ACCESS_TOKEN" To iSuccess
Get Create (RefClass(cComChilkatStringBuilder)) To hoSbResponseBody
If (Not(IsComObjectCreated(hoSbResponseBody))) Begin
Send CreateComObject of hoSbResponseBody
End
Get pvComObject of hoSbResponseBody to vSbResponseBody
Get ComFullRequestNoBodySb Of hoRest "GET" "/api/data/v9.0/products" vSbResponseBody To iSuccess
If (iSuccess <> True) Begin
Get ComLastErrorText Of hoRest To sTemp1
Showln sTemp1
Procedure_Return
End
Get ComResponseStatusCode Of hoRest To iRespStatusCode
If (iRespStatusCode >= 400) Begin
Showln "Response Status Code = " iRespStatusCode
Showln "Response Header:"
Get ComResponseHeader Of hoRest To sTemp1
Showln sTemp1
Showln "Response Body:"
Get ComGetAsString Of hoSbResponseBody To sTemp1
Showln sTemp1
Procedure_Return
End
Get Create (RefClass(cComChilkatJsonObject)) To hoJsonResponse
If (Not(IsComObjectCreated(hoJsonResponse))) Begin
Send CreateComObject of hoJsonResponse
End
Get pvComObject of hoSbResponseBody to vSbResponseBody
Get ComLoadSb Of hoJsonResponse vSbResponseBody To iSuccess
Get ComStringOf Of hoJsonResponse '"@odata.context"' To sOdataContext
Move 0 To i
Get ComSizeOfArray Of hoJsonResponse "value" To iCount_i
While (i < iCount_i)
Set ComI Of hoJsonResponse To i
Get ComStringOf Of hoJsonResponse 'value[i]."@odata.etag"' To sOdataEtag
Get ComStringOf Of hoJsonResponse "value[i].name" To sName
Get ComStringOf Of hoJsonResponse "value[i].description" To sDescription
Get ComStringOf Of hoJsonResponse "value[i].productid" To sProductid
Get ComStringOf Of hoJsonResponse "value[i].productnumber" To sProductnumber
Get ComIntOf Of hoJsonResponse "value[i].quantitydecimal" To iQuantitydecimal
Get ComStringOf Of hoJsonResponse "value[i].vendorpartnumber" To sVendorpartnumber
Get ComIntOf Of hoJsonResponse "value[i].price" To iPrice
Get ComStringOf Of hoJsonResponse "value[i].vendorname" To sVendorname
Get ComIntOf Of hoJsonResponse "value[i].standardcost" To iStandardcost
Get ComIntOf Of hoJsonResponse "value[i].quantityonhand" To iQuantityonhand
Get ComStringOf Of hoJsonResponse "value[i]._transactioncurrencyid_value" To sV_transactioncurrencyid_value
Move i + 1 To i
Loop
End_Procedure
{
"@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"
}
]
}