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

Swift Example


func chilkatTest() {
    let rest = CkoRest()
    var success: Bool

    //  URL: https://my-dynamics-domain.api.crm.dynamics.com/api/data/v9.0/products
    var bTls: Bool = true
    var port: Int = 443
    var bAutoReconnect: Bool = true
    success = rest.Connect("my-dynamics-domain.api.crm.dynamics.com", port: port, tls: bTls, autoReconnect: bAutoReconnect)
    if success != true {
        print("ConnectFailReason: \(rest.ConnectFailReason.intValue)")
        print("\(rest.LastErrorText)")
        return
    }

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

    rest.AddHeader("OData-MaxVersion", value: "4.0")
    rest.AddHeader("Accept", value: "application/json")
    rest.AddHeader("OData-Version", value: "4.0")
    rest.AddHeader("Authorization", value: "Bearer DYNAMICS_CRM_ACCESS_TOKEN")

    let sbResponseBody = CkoStringBuilder()
    success = rest.FullRequestNoBodySb("GET", uriPath: "/api/data/v9.0/products", sb: sbResponseBody)
    if success != true {
        print("\(rest.LastErrorText)")
        return
    }

    var respStatusCode: Int = rest.ResponseStatusCode.intValue
    if respStatusCode >= 400 {
        print("Response Status Code = \(respStatusCode)")
        print("Response Header:")
        print("\(rest.ResponseHeader)")
        print("Response Body:")
        print("\(sbResponseBody.GetAsString())")
        return
    }

    let jsonResponse = CkoJsonObject()
    jsonResponse.LoadSb(sbResponseBody)

    var i: Int
    var count_i: Int

    var odataContext: String? = jsonResponse.StringOf("\"@odata.context\"")
    i = 0
    count_i = jsonResponse.SizeOfArray("value").intValue
    while i < count_i {
        jsonResponse.I = i
        var odataEtag: String? = jsonResponse.StringOf("value[i].\"@odata.etag\"")
        var name: String? = jsonResponse.StringOf("value[i].name")
        var description: String? = jsonResponse.StringOf("value[i].description")
        var productid: String? = jsonResponse.StringOf("value[i].productid")
        var productnumber: String? = jsonResponse.StringOf("value[i].productnumber")
        var quantitydecimal: Int = jsonResponse.IntOf("value[i].quantitydecimal").intValue
        var vendorpartnumber: String? = jsonResponse.StringOf("value[i].vendorpartnumber")
        var price: Int = jsonResponse.IntOf("value[i].price").intValue
        var vendorname: String? = jsonResponse.StringOf("value[i].vendorname")
        var standardcost: Int = jsonResponse.IntOf("value[i].standardcost").intValue
        var quantityonhand: Int = jsonResponse.IntOf("value[i].quantityonhand").intValue
        var v_transactioncurrencyid_value: String? = 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"
    }
  ]
}