Export Line Items

[MMahmoud70]

Hi there,

I would like to export the entire list of our Line Items Record ID and a custom property. I can tell there is no option to export Line Items for time being. However, I tried exporting them via Reports. But, the reports doesn't show Record ID for the line item. Also, I tried the BATCH read endpoint. But, it requires a criteria to be met in order to return some line items and I wish to get all of them no matter what.

Is there a way to accomplish this?

Sincerely,
Mohamed Mahmoud

[sherrychen]

hi @MMahmoud70 ,

You may want to check out this tool in marketplace, it is spreadsheet view which allows you to filter/search/export deal line items. We use it to quickly add line-item to deals, but the filter function might be helpful in your use case

Best

SC

[DMcCaskill]

The link for the tool no longer is active - goes to a "That page is nowhere to be found" error. 

[DanSullivan]

Hi! We are also needing this, it's very inconvenient not being able to get an export easily for line items - are there any updates on getting this feature? 

[MiaSrebrnjak]

Hi @DanSullivan, thank you for your feedback.

Using the API endpoint is currently still the recommended way to export line items in bulk (you can find line item API developer documentation here).

It'd be great if you could also share your feedback in our HubSpot Idea Forum. We use it to collect ideas on how we can improve the product for our customers. Product pays particular attention to the top voted ideas & takes them into consideration along with other feedback channels as well as their own vision to understand what features will be most valuable. Thank you!

Mia, Community team 

[Levi · Accepted solution]

Hi @MMahmoud70, this is possible via API. See this link. 

curl --request GET \
--url 'https://api.hubapi.com/v4/objects/line_items//associations/?limit=500' \
--header 'authorization: Bearer YOUR_ACCESS_TOKEN'