Fetch orders using Order ID

Authorization

Step 1:

Fetch all connection ids from the channels table using a filter of integration type.

SELECT channels.connectionId
FROM channels
WHERE integrationType =: TataCliqIntegrationType

The above query will return a list of connection ids of all TataCliq integrations.

Step 2:

For each connection id, fetch TataCliq access token from ie_appinstall_connection table using the connectionId.

SELECT ie_appinstall_connection.accessToken
FROM ie_appinstall_connection
WHERE id =: connectionId

Place the access token in request headers in the following key-value format.

Key	Value

Key	Value
Authorization	Bearer <AccessToken>

API

Order ID can be mentioned at the end of the URL in the ORDID_{{orderID}} format.

API URL (HTTP GET method):

https://intapppreprod2.tataunistore.com/PartnerConnect/PC_{{Seller_ID}}/AP_SALES_ORDER/AVT_JSON_SALES_ORDER/AV_2.0/OG_1/ORDID_{{orderID}}/

Note that the URL is not same as AP_SALES_ORDER API which we used to fetch all active orders provided at the “Fetch all active orders” page. The filters do not work on the fetch all sales order URL.

Example OrderID filter API URL:

https://intapppreprod2.tataunistore.com/PartnerConnect/PC_124346/AP_SALES_ORDER/AVT_JSON_SALES_ORDER/AV_2.0/OG_1/ORDID_74623-452-969027/

Response Body:

{
    "order": [
        {
            "orderType": "01",
            "orderNo": "74623-452-969027",
            "orderDate": "2021-08-20 10:45:59.0",
            "addressInfo": [
                {
                    "addressType": "DA",
                    "emailID": "nitish.yadav@anmsoft.com",
                    "firstName": "Nitish",
                    "lastName": "Yadav",
                    "phoneNo": "9916221729",
                    "address1": "Kaveri Building",
                    "address2": "Lodha",
                    "address3": "Heavan",
                    "landmark": "Near to Royal medical--",
                    "country": "IN",
                    "city": "Dombivali",
                    "state": "27  ",
                    "pincode": "400083"
                },
                {
                    "addressType": "BA",
                    "emailID": "nitish.yadav@anmsoft.com",
                    "firstName": "Nitish",
                    "lastName": "Yadav",
                    "phoneNo": "9916221729",
                    "address1": "Kaveri",
                    "address2": "Lodha Heavan",
                    "address3": "Neelje",
                    "landmark": "Near to Royal medical",
                    "country": "IN",
                    "city": "Dombivali",
                    "state": "27  ",
                    "pincode": "400083"
                }
            ],
            "paymentInfo": [
                {
                    "paymentCost": 999.0,
                    "paymentMode": "PREPAID",
                    "paymentType": "UPI",
                    "paymentRefId": "983921234",
                    "paymentStatus": "S",
                    "paymentInfo": "112185946-1616482779497",
                    "paymentDate": "2021-07-30 12:29:40.0"
                }
            ],
            "orderLine": [
                {
                    "transactionId": "1463467238351",
                    "shipByDate": "",
                    "originalTransactionId": "14365662",
                    "omsStatusCode": "001",
                    "sellerID": "124346",
                    "articleNumber": "17AW16804-429-102-M",
                    "imageUrl": "https://img.tatacliq.com/images/i3/252Wx374H/MP000000003481090_252Wx374H_20180803203501.jpeg",
                    "taxType": "IGST",
                    "taxValue": "5.00",
                    "price": 1100.0,
                    "mrp": 3000.0,
                    "isCOD": "N",
                    "apportionedPrice": 1000.0,
                    "apportionedCODPrice": 0.0,
                    "apportionedShippingCharge": 0.0,
                    "isaGift": "N",
                    "giftPrice": 0.0,
                    "deliveryMode": "ED",
                    "isPrecious": "N",
                    "isFragile": "N",
                    "transportMode": "AIR",
                    "fulfillmentType": "TSHIP",
                    "p1SlaveId": "JPCUP",
                    "p1LogisticsID": "EK",
                    "prepaidLimit1": "200000.0",
                    "p2LogisticsID": "EK",
                    "prepaidLimit2": "0.0",
                    "returnLogisticsID": "EK",
                    "alternateContactName": "N",
                    "alternatePhoneNo": "N",
                    "gst": {
                        "slavegstin": "09AAAFJ3235A1ZY",
                        "destinationStateCode": "27",
                        "hsnCode": "61091000",
                        "hsnTax": [
                            {
                                "taxType": "IGST",
                                "taxRate": "5",
                                "taxValue": "47.62"
                            }
                        ],
                        "sacCodeSchedulingCharges": "996819",
                        "schedulingChargesTAXES": [
                            {
                                "taxType": "IGST",
                                "taxRate": "18",
                                "taxValue": "0.00"
                            }
                        ],
                        "sacCodeShipCharges": "996819",
                        "shippingChargesTAXES": [
                            {
                                "taxType": "IGST",
                                "taxRate": "18",
                                "taxValue": "0.00"
                            }
                        ],
                        "giftingCharges": "0.00",
                        "giftingChargesTAXES": []
                    },
                    "promotionInfo": [
                        {
                            "promotionCode": "PROMOTATA100",
                            "promotionValue": "0.00",
                            "tatareimbursepercent": "0.00"
                        },
                        {
                            "promotionCode": "PROMOTATA101",
                            "promotionValue": "0.00",
                            "tatareimbursepercent": "0.00"
                        }
                    ],
                    "coupon": [
                        {
                            "couponCode": "cpn2",
                            "couponValue": "100.00",
                            "tatareimbursepercent": "0.00"
                        },
                        {
                            "couponCode": "COUPON61",
                            "couponValue": "0.00",
                            "tatareimbursepercent": "0.00"
                        }
                    ],
                    "isLuxury": "N",
                    "isLocal": "N",
                    "customerGSTIN": "",
                    "packId": "746539234614JPCUPAA"
                }
            ]
        }
    ]
}

Apps and Automations