# Line Items API

**URL:** <https://community.hubspot.com/t/line-items-api/134005>\
**Category:** APIs & Integrations\
**Tags:** starter\
**Created:** [June 5, 2025, 1:34pm UTC](https://community.hubspot.com/t/line-items-api/134005 "2025-06-05T13:34:20Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![JMeli](https://avatars.discourse-cdn.com/v4/letter/j/c68b51/32.png) [@JMeli](https://community.hubspot.com/u/JMeli)\
**Post date:** [June 5, 2025, 1:34pm UTC](https://community.hubspot.com/t/line-items-api/134005/1 "2025-06-05T13:34:20Z")

</div>

We are using the Line Items API in our company. This was working a couple of weeks ago and then suddenly stopped. We created a Power Automate Automation which grabs the report, creates a CSV and then uploads to our SharePoint.

Is there anyone in this forum who can help me?

---

<div class="post-metadata">

**Author:** ![Jaycee\_Lewis](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jaycee_lewis/32/61352_2.png) [@Jaycee\_Lewis](https://community.hubspot.com/u/Jaycee_Lewis)\
**Post date:** [June 5, 2025, 7:26pm UTC](https://community.hubspot.com/t/line-items-api/134005/2 "2025-06-05T19:26:16Z")

</div>

Hey, @JMeli 👋 Thanks for the question. Sorry to hear your Power Automate–HubSpot Line Items API → CSV → SharePoint automation suddenly broke.

Quick things to check:

- Check Power Automate connections: Sometimes HubSpot or SharePoint logins or tokens expire/reset.
- Review recent changes: API updates or changes to field names, permissions in HubSpot, or SharePoint schema can cause silent breaks.
- Error messages: Check your flow run history in Power Automate for specific failure points or messages.
- Double check if your SharePoint columns changed type (e.g., text to number, single to multi-line), update your flow to match.  
[**Example fix for column type errors**](https://community.powerplatform.com/forums/thread/details/?threadid=36db26a3-d5e2-49bb-a1f8-bb4c77eec6cb)

You can also make a quick test using Postman and the [**Line Items API**](https://developers.hubspot.com/docs/guides/api/crm/commerce/line-items) to verify your token still works and the API itself is behaving as expected. This might help rule out a few options fairly quickly.

Resources:

- [**HubSpot Line Items API documentation**](https://developers.hubspot.com/docs/api/crm/line-items)
- [**Microsoft Power Automate SharePoint guide**](https://learn.microsoft.com/en-us/power-automate/connection-sharepoint-online)
- [**Troubleshoot Flow Failures**](https://learn.microsoft.com/en-us/power-automate/fix-flow-failures)

Lastly, If possible, can you copy the error message from Power Automate’s failed run and paste it here? It makes it much easier for the community to help.

Talk soon! — Jaycee

---

<div class="post-metadata">

**Author:** ![JMeli](https://avatars.discourse-cdn.com/v4/letter/j/c68b51/32.png) [@JMeli](https://community.hubspot.com/u/JMeli)\
**Post date:** [June 6, 2025, 8:38am UTC](https://community.hubspot.com/t/line-items-api/134005/3 "2025-06-06T08:38:41Z")

</div>

Hi Jaycee,  
Thanks for your help with this. Would it be possible to have a call with a dev to help us troubleshoot this? Just think it would be easier to go through the automation with someone.