Line Items API

Develop, Build & Integrate APIs & Integrations
1

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?

2

Hey, @JMeli :waving_hand: 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

You can also make a quick test using Postman and the Line Items API 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:

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

3

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.