Perl 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"

Perl Example

use chilkat();

$rest = chilkat::CkRest->new();

#  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) {
    print "ConnectFailReason: " . $rest->get_ConnectFailReason() . "\r\n";
    print $rest->lastErrorText() . "\r\n";
    exit;
}

$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 = chilkat::CkStringBuilder->new();
$success = $rest->FullRequestNoBodySb("GET","/api/data/v9.0/products",$sbResponseBody);
if ($success != 1) {
    print $rest->lastErrorText() . "\r\n";
    exit;
}

$respStatusCode = $rest->get_ResponseStatusCode();
if ($respStatusCode >= 400) {
    print "Response Status Code = " . $respStatusCode . "\r\n";
    print "Response Header:" . "\r\n";
    print $rest->responseHeader() . "\r\n";
    print "Response Body:" . "\r\n";
    print $sbResponseBody->getAsString() . "\r\n";
    exit;
}

$jsonResponse = chilkat::CkJsonObject->new();
$jsonResponse->LoadSb($sbResponseBody);

$odataContext = $jsonResponse->stringOf('\'@odata.context\'');
$i = 0;
$count_i = $jsonResponse->SizeOfArray("value");
while ($i < $count_i) {
    $jsonResponse->put_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;
}

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"
    }
  ]
}