How to get the value of the order the line items appear on a Hubspot deal?SOLVE
Oct 9, 2019 1:02 PM - edited Oct 9, 2019 1:56 PM
Our customers at Paycove use Hubspot products to create invoices, quotes, and other documents. After our users add line items to a deal in Hubspot, they want the line items to appear in the same order in Paycove.
We're currently pulling in the line items for a deal using the CRM Associations endpoint (code 19). However, "display_order" of the deal is not an available field, only the "hs_quote_display_order". This is problematic because most of our customers don't create quotes on Hubspot, but use Paycove to create invoices / quotes. I've tried sorting the line items by the HS created datetime, but it appears that this does not respect the order the line items appear on the deal either.
Example: line item order in Hubspot: https://d.pr/free/i/dsBHVK
Line item order returned through CRM Assocations endpoint: https://d.pr/free/i/5kmSm5
Any suggestions on this?
Solved! Go to Solution.
Oct 10, 2019 10:45 PM
I hope all is well with you 😄
On my end, I created a deal and added five products like this:
This is product one
This is product two
This is product three
This is product four
This is product five
Next, I used this endpoint: Get associations for CRM object and I was return the following results:
240363021 (the line item id)
240363022 (the line item id)
240363024 (the line item id)
240363025 (the line item id)
240363026 (the line item id)
Plucking in those line item id into this endpoint: Get line item by ID, I was able to see that the results of the product in the line items is showing the same as what I'm seeing on the UI.
In this case, would you mind sharing with me an example deal where you're seeing a mismatch of the display order from the UI and the endpoint?