Unicode C 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"

Unicode C Example

#include <C_CkRestW.h>
#include <C_CkStringBuilderW.h>
#include <C_CkJsonObjectW.h>

void ChilkatSample(void)
    {
    HCkRestW rest;
    BOOL success;
    BOOL bTls;
    int port;
    BOOL bAutoReconnect;
    HCkStringBuilderW sbResponseBody;
    int respStatusCode;
    HCkJsonObjectW jsonResponse;
    int i;
    int count_i;
    const wchar_t *odataContext;
    const wchar_t *odataEtag;
    const wchar_t *name;
    const wchar_t *description;
    const wchar_t *productid;
    const wchar_t *productnumber;
    int quantitydecimal;
    const wchar_t *vendorpartnumber;
    int price;
    const wchar_t *vendorname;
    int standardcost;
    int quantityonhand;
    const wchar_t *v_transactioncurrencyid_value;

    rest = CkRestW_Create();

    //  URL: https://my-dynamics-domain.api.crm.dynamics.com/api/data/v9.0/products
    bTls = TRUE;
    port = 443;
    bAutoReconnect = TRUE;
    success = CkRestW_Connect(rest,L"my-dynamics-domain.api.crm.dynamics.com",port,bTls,bAutoReconnect);
    if (success != TRUE) {
        wprintf(L"ConnectFailReason: %d\n",CkRestW_getConnectFailReason(rest));
        wprintf(L"%s\n",CkRestW_lastErrorText(rest));
        CkRestW_Dispose(rest);
        return;
    }

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

    CkRestW_AddHeader(rest,L"OData-MaxVersion",L"4.0");
    CkRestW_AddHeader(rest,L"Accept",L"application/json");
    CkRestW_AddHeader(rest,L"OData-Version",L"4.0");
    CkRestW_AddHeader(rest,L"Authorization",L"Bearer DYNAMICS_CRM_ACCESS_TOKEN");

    sbResponseBody = CkStringBuilderW_Create();
    success = CkRestW_FullRequestNoBodySb(rest,L"GET",L"/api/data/v9.0/products",sbResponseBody);
    if (success != TRUE) {
        wprintf(L"%s\n",CkRestW_lastErrorText(rest));
        CkRestW_Dispose(rest);
        CkStringBuilderW_Dispose(sbResponseBody);
        return;
    }

    respStatusCode = CkRestW_getResponseStatusCode(rest);
    if (respStatusCode >= 400) {
        wprintf(L"Response Status Code = %d\n",respStatusCode);
        wprintf(L"Response Header:\n");
        wprintf(L"%s\n",CkRestW_responseHeader(rest));
        wprintf(L"Response Body:\n");
        wprintf(L"%s\n",CkStringBuilderW_getAsString(sbResponseBody));
        CkRestW_Dispose(rest);
        CkStringBuilderW_Dispose(sbResponseBody);
        return;
    }

    jsonResponse = CkJsonObjectW_Create();
    CkJsonObjectW_LoadSb(jsonResponse,sbResponseBody);

    odataContext = CkJsonObjectW_stringOf(jsonResponse,L"\"@odata.context\"");
    i = 0;
    count_i = CkJsonObjectW_SizeOfArray(jsonResponse,L"value");
    while (i < count_i) {
        CkJsonObjectW_putI(jsonResponse,i);
        odataEtag = CkJsonObjectW_stringOf(jsonResponse,L"value[i].\"@odata.etag\"");
        name = CkJsonObjectW_stringOf(jsonResponse,L"value[i].name");
        description = CkJsonObjectW_stringOf(jsonResponse,L"value[i].description");
        productid = CkJsonObjectW_stringOf(jsonResponse,L"value[i].productid");
        productnumber = CkJsonObjectW_stringOf(jsonResponse,L"value[i].productnumber");
        quantitydecimal = CkJsonObjectW_IntOf(jsonResponse,L"value[i].quantitydecimal");
        vendorpartnumber = CkJsonObjectW_stringOf(jsonResponse,L"value[i].vendorpartnumber");
        price = CkJsonObjectW_IntOf(jsonResponse,L"value[i].price");
        vendorname = CkJsonObjectW_stringOf(jsonResponse,L"value[i].vendorname");
        standardcost = CkJsonObjectW_IntOf(jsonResponse,L"value[i].standardcost");
        quantityonhand = CkJsonObjectW_IntOf(jsonResponse,L"value[i].quantityonhand");
        v_transactioncurrencyid_value = CkJsonObjectW_stringOf(jsonResponse,L"value[i]._transactioncurrencyid_value");
        i = i + 1;
    }



    CkRestW_Dispose(rest);
    CkStringBuilderW_Dispose(sbResponseBody);
    CkJsonObjectW_Dispose(jsonResponse);

    }

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