how to search quote via script

[pritam_kaur26]

Below is the sample order status message received from fulfillment system, want to know how can I search for the quote having PO number "50-52577-D" and shipto company name as "INGRAM MICRO INC" in order to update quote with status details.

{

"orders": [

{

"order_num": "604084820",

"quote_number": "3000142089949/1",

"po_details": {

"purchase_order_no": "50-52577-D",

"purchase_order_lines": [

{

"line_number": "000001"

}

]

},

"ship_to_customer": {

"customer_num": "530030587800",

"customer_first_name": "JENSEN",

"customer_last_name": "BOBBI",

"company_name": "BISH S RV - IDAHO FALLS",

"customer_address": [

"3855 N 5TH E",

"JEREMY CHRISTIAN",

"IDAHO FALLS",

"Idaho",

"United States"

],

"customer_postal_code": "83401-1132",

"customer_phone": [

"8888888"

],

"customer_name": "JENSEN BOBBI",

"customer_email": [

"TKITE@BISHS.COM"

]

}

}

],

"total_result_count": "1"

}'''

[LukaPilipovic]

In order to get better guidance can you please share how your landscape looks like, do you use quote 1.0 or quote 2.0? Reason why I'm asking for this is because way of looking for it will be highly dependant on how you keep this relationship.

[pritam_kaur26]

Attached is the landscape of the order tab

landscape.png

[yogananda]

pritam.kaur26

Are you sure you're using SAP CPQ ? Because the quote number in your payload appears to be different then SAP CPQ generates, and the structure of the json is also different. Kindly confirm once more or re-assign the tag to the right product, so you get reply from others quickly.

[pritam_kaur26]

Above Payload is the message from our order fulfillment system, I need to use the data and display appropriately status of the order in SAP CPQ system. for that I need to match the message with the correct quote. This message doesn't contain SAP CPQ quote number but PO number is something common between the two. Hence I plan to pull the quote using the PO number first and then update the quote with required data.

[yogananda]

pritam.kaur26

thanks for giving more information and as well landscape.jpg screenshot. so My question is how do you get PO Number into SAP CPQ ? Does PO Number is a custom field in your CPQ Quotation ? if yes the solution is to find it through GET method /api/v1/quote/quoteid/customfield and you can pass all the necessary information back with POST Method

API Documentation : refer quotes endpoint

https://eudev.webcomcpq.com/webapihelp/index

[paultrozan]

Easier than calling an API, you can search via PO Number directly in the UI. It should look like this:

If this field is not displaying, a CPQ admin can add it by going to the Quotes -> Search Fields area inside of Setup. Hope this helps!