filter logic for Oreders

Question

I am using the filter logic below for "Orders" and I get the response with "null" see below. Is the filter logic is correct or not?

((Content/OrderHeader/OrderNumber eq '13963189') and (ItemType eq 'Order'))

{
"orderHeader": {
"systemId": null,
"SOId": "",
"customerKey": "",
"customerCode": "",
"salesTypeCode": "",
"orderDate": null,
"orderTime": "",
"orderedBy": "",
"salesCode": "",
"agentCode": "",
"jobNumber": "",
"referenceNumber": "",
"poNumber": "",
"shipViaCode": "",
"shipToSequenceNumber": "",
"orderSubtotalAmount": "",
"SOChargeAmount": "",
"taxAmount": "",
"orderTotalAmount": "",
"routeCode": "",
"routeDescription": "",
"SOStatusCode": "",
"shipStatusCode": "",
"deliveryStatus": "",
"descartesTimeStamp": null,
"status": "",
"SOStatusDescription": "",
"SOTypeCode": "",
"paymentTermsCode": "",
"expectedDate": null,
"firstShipmentDate": null,
"billToName": "",
"billToAddress": {
"addressLine1": "",
"addressLine2": "",
"addressLine3": "",
"city": "",
"state": "",
"zipCode": null
},
"billToPhones": [
{
"phoneNumber": "",
"type": "business"
},
{
"phoneNumber": "",
"type": "fax"
}
],
"customerJobName": "",
"customerJobAddress": {
"addressLine1": "",
"addressLine2": "",
"addressLine3": "",
"city": "",
"state": "",
"zipCode": null
},
"customerJobPhone": [
{
"phoneNumber": "",
"type": "business"
}
],
"destinationContact": "",
"destinationPhone": [
{
"phoneNumber": "",
"type": "fax"
},
{
"phoneNumber": "",
"type": "business"
}
],
"destinationShipmentNumber": "",
"headerNote": "",
"branchCode": "",
"branchId": "",
"branchName": "",
"branchAddress": {
"addressLine1": "",
"addressLine2": "",
"addressLine3": "",
"city": "",
"state": "",
"zipCode": null
},
"branchPhones": [
{
"phoneNumber": "",
"type": "business"
},
{
"phoneNumber": "",
"type": "fax"
}
],
"brandName": "",
"brandLogoURL": null,
"deliveryDate": null,
"deliveryWindow": "",
"shipToLatitude": null,
"shipToLongitude": null,
"customerPONumber": null,
"sourceSystem": null,
"transactionId": null,
"jobName": null
},
"orderDetails": []
}

Answer 1

thanks for the response her is the detail;

Description
Point orders details and list in orders system api to azure search endpoint instead of the ODS (data warehouse)

Answer 2

And here is the request and response to the Deve.

the call is, a Get call for Order System Api.

body:

{
"branchCode": "djkan",
"customerNumber": "asp130",
"shipToSequenceNumber": null,
"orderId": null,
"orderFromDate": "2019-07-20",
"orderToDate": null,
"rowReturnLimit": 10000,
"orderStatus": "",
"PONumber":"",
"jobNumber":"",
"shipToAddress":""
}

Response:

{
"orderHeader": {
"systemId": 740,
"SOId": 13963189,
"customerKey": "00067230",
"customerCode": "BLA242",
"salesTypeCode": "whse",
"orderDate": "2019-03-28",
"orderTime": "10:57:56",
"orderedBy": "email Adam",
"salesCode": "ERUTHRAUFF",
"agentCode": "ERUTHRAUFF",
"jobNumber": "",
"referenceNumber": "",
"poNumber": "26216",
"shipViaCode": "GROUND DROP",
"shipToSequenceNumber": "1",
"orderSubtotalAmount": 1354.10,
"SOChargeAmount": 0.00,
"taxAmount": 106.44,
"orderTotalAmount": 1460.54,
"routeCode": "DAILY",
"routeDescription": "Anytime",
"SOStatusCode": "I",
"shipStatusCode": "I",
"deliveryStatus": "",
"descartesTimeStamp": null,
"status": "Invoiced",
"SOStatusDescription": "INVOICED",
"SOTypeCode": "SO",
"paymentTermsCode": "2%2ND10TH60",
"expectedDate": "2019-03-29",
"firstShipmentDate": "2019-03-28",
"billToName": "BLACK ROOFING INC",
"billToAddress": {
"addressLine1": "6115 BEN PLACE",
"addressLine2": "",
"addressLine3": "",
"city": "BOULDER",
"state": "CO",
"zipCode": "80301"
},
"billToPhones": [
{
"phoneNumber": "3034495176",
"type": "business"
},
{
"phoneNumber": "3034498473",
"type": "fax"
}
],
"customerJobName": "BLACK ROOFING INC",
"customerJobAddress": {
"addressLine1": "6115 BEN PLACE",
"addressLine2": "",
"addressLine3": "",
"city": "BOULDER",
"state": "CO",
"zipCode": "80301"
},
"customerJobPhone": [
{
"phoneNumber": "3034495176",
"type": "business"
}
],
"destinationContact": "Tim Black",
"destinationPhone": [
{
"phoneNumber": "3034498473",
"type": "fax"
},
{
"phoneNumber": "3034495176",
"type": "business"
}
],
"destinationShipmentNumber": "1",
"headerNote": " ",
"branchCode": "AMDEN",
"branchId": 270,
"branchName": "AMERICAN ROOFING SUPPLY - DENVER",
"branchAddress": {
"addressLine1": "4550 E. 52ND AVENUE",
"addressLine2": "",
"addressLine3": "",
"city": "DENVER",
"state": "CO",
"zipCode": "80217"
},
"branchPhones": [
{
"phoneNumber": "303-333-3700",
"type": "business"
},
{
"phoneNumber": "303-333-3786",
"type": "fax"
}
],
"brandName": "AMERICAN ROOFING SUPPLY",
"brandLogoURL": "https://media.srsdistribution.com/Uploads/BrandsByID/38.png",
"deliveryDate": "2019-03-29",
"deliveryWindow": "Anytime",
"shipToLatitude": 40.0163623000000,
"shipToLongitude": -105.2088382000000,
"customerPONumber": null,
"sourceSystem": null,
"transactionId": null,
"jobName": null
},
"orderDetails": [
{
"systemId": 740,
"SOId": "13963189",
"sequenceNumber": 1,
"orderQty": 10.0000,
"shipQtyConv": 10.000000,
"UOM": "RL",
"itemCode": "ETEWS6",
"itemDescription": "ETERNABOND WEBSEAL",
"itemExtendedDescription": "",
"itemSize": "6\" X 50'",
"priceQty": 10.0000,
"priceAmount": 69.2500,
"priceUOM": "RL",
"extendedPriceAmount": 692.5000,
"shipmentNumber": 1,
"shipmentStatusCode": "I",
"invoiceDate": "2019-03-29",
"shipQty": 10.0000,
"shipUOM": "RL"
},
{
"systemId": 740,
"SOId": "13963189",
"sequenceNumber": 2,
"orderQty": 2.0000,
"shipQtyConv": 2.000000,
"UOM": "CTN",
"itemCode": "PCN13000",
"itemDescription": "PLASTIC CAP NAIL",
"itemExtendedDescription": "",
"itemSize": "1\" 3000/BX",
"priceQty": 2.0000,
"priceAmount": 23.0000,
"priceUOM": "CTN",
"extendedPriceAmount": 46.0000,
"shipmentNumber": 1,
"shipmentStatusCode": "I",
"invoiceDate": "2019-03-29",
"shipQty": 2.0000,
"shipUOM": "CTN"
},
{
"systemId": 740,
"SOId": "13963189",
"sequenceNumber": 3,
"orderQty": 24.0000,
"shipQtyConv": 24.000000,
"UOM": "TB",
"itemCode": "GEO2320AG",
"itemDescription": "GEOCEL 2320 SEAL ALUMINUM GRAY",
"itemExtendedDescription": "",
"itemSize": "10.3 OZ",
"priceQty": 24.0000,
"priceAmount": 4.7500,
"priceUOM": "TB",
"extendedPriceAmount": 114.0000,
"shipmentNumber": 1,
"shipmentStatusCode": "I",
"invoiceDate": "2019-03-29",
"shipQty": 24.0000,
"shipUOM": "TB"
},
{
"systemId": 740,
"SOId": "13963189",
"sequenceNumber": 4,
"orderQty": 4.0000,
"shipQtyConv": 4.000000,
"UOM": "3G",
"itemCode": "KAR19UW3",
"itemDescription": "KARNAK 19 ULTRA WINTER FLASHING CEMENT",
"itemExtendedDescription": "WINTER GRADE",
"itemSize": "3 GAL",
"priceQty": 4.0000,
"priceAmount": 39.0000,
"priceUOM": "3G",
"extendedPriceAmount": 156.0000,
"shipmentNumber": 1,
"shipmentStatusCode": "I",
"invoiceDate": "2019-03-29",
"shipQty": 4.0000,
"shipUOM": "3G"
},
{
"systemId": 740,
"SOId": "13963189",
"sequenceNumber": 5,
"orderQty": 3.0000,
"shipQtyConv": 3.000000,
"UOM": "3G",
"itemCode": "KAR5023",
"itemDescription": "KARNAK 502 KARNA-FLEX SEAM SEALER",
"itemExtendedDescription": "",
"itemSize": "3 GAL",
"priceQty": 3.0000,
"priceAmount": 115.2000,
"priceUOM": "3G",
"extendedPriceAmount": 345.6000,
"shipmentNumber": 1,
"shipmentStatusCode": "I",
"invoiceDate": "2019-03-29",
"shipQty": 3.0000,
"shipUOM": "3G"
}
]
}