topic Re: HubSpot API - How to Update Invoice Status (Currently Read-Only) in APIs & Integrations

HubSpot API - How to Update Invoice Status (Currently Read-Only)

CZangabee — Tue, 17 Sep 2024 14:38:28 GMT

Hi everyone,

We're currently working on an integration where we push invoice statuses from another system into HubSpot. However, we've noticed that the invoice status in HubSpot appears to be read-only through the API, and we need to map and update this status in HubSpot to reflect changes from the external system.

Has anyone encountered a similar issue, or does anyone know of a workaround or API setting that allows for invoice status updates? Any help or guidance would be appreciated!

Re: HubSpot API - How to Update Invoice Status (Currently Read-Only)

CZangabee — Tue, 17 Sep 2024 15:30:58 GMT

After further investigation, it seems there might be an alternative solution using HubSpot workflows. We could set up a daily workflow that fetches the invoice status from the external system and checks only invoices in Hubspot with the criteria "Open" invoice status. The workflow would run multiple times per day, allowing us to update the invoice status based on the external data.

However, this daily scheduling is not for free.
If anyone else has had experience with this approach or an alternative solution, please feel free to share!

Re: HubSpot API - How to Update Invoice Status (Currently Read-Only)

GRajput — Wed, 18 Sep 2024 13:05:07 GMT

Hi @CZangabee

As it read-only property in HubSpot, you won't be able to update it. A common workaround is to create a custom property on the invoice object or another relevant object and use that to track and update the invoice status from your external system. This custom property can then reflect the status changes as needed.

I hope this will help you out. Please mark it as Solution Accepted and upvote to help another Community member.
Thanks!

Re: HubSpot API - How to Update Invoice Status (Currently Read-Only)

CZangabee — Fri, 27 Sep 2024 10:49:02 GMT

Hi @GRajput
I have created a custom property on the Invoice. However it is not possible to update that custom property as well
For example
https://api.hubapi.com/crm/v3/objects/invoices/154116145368
PATCH
body:
{
"properties": {
"netsuite_hubspot_invoice_status": "PAID"
}
}

resulsts in:
{
"status": "error",
"message": "The scope needed for this API call isn't available for public use. If you have questions, contact support or post in our developer forum.",
"correlationId": "x",
"links": {
"support": "https://help.hubspot.com/",
"forum": "https://community.hubspot.com/t5/APIs-Integrations/bd-p/integrations"
},
"category": "MISSING_SCOPES"
}