topic Re: Access invoices data via API in APIs & Integrations

Access invoices data via API

Ignazio — Tue, 17 Oct 2023 10:37:17 GMT

Hello everyone!

As of February 28, 2023, the Accounting extension API has been deprecated.

We need to access the invoices data via API, as we were able to do in the past: could you please suggest to us any way to do it?

Thank you in advance,

Re: Access invoices data via API

TDwebdev — Tue, 17 Oct 2023 13:42:35 GMT

Hi Ignazio,

You can check: https://developers.hubspot.com/docs/api/crm/quotes

Here you can get access to the quotes of HubSpot

Re: Access invoices data via API

Ignazio — Tue, 17 Oct 2023 13:48:37 GMT

Hi @TDwebdev and thank you for your quick reply!

I need to access the invoice object. Here you have some reference:

I don't think the quotes API will help me.

Re: Access invoices data via API

TDwebdev — Tue, 17 Oct 2023 13:56:12 GMT

Try this endpoint: https://api.hubapi.com/crm/v3/objects/{objectName}/{objectId}

Re: Access invoices data via API

Ignazio — Tue, 17 Oct 2023 15:31:00 GMT

Hi @TDwebdev and thank you again!

This is the reply I have from the API call:

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.

Re: Access invoices data via API

CharlieL — Thu, 26 Oct 2023 16:22:58 GMT

Hi @TDwebdev,

We're having the same issue as @Ignazio. When trying to call Invoices through the https://api.hubapi.com/crm/v3/objects/{objectName}/{objectId} endpoint (with the corresponding objectName), we're getting the same 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.

Any further help would be super appreciated!

Thanks,

Charlie

Re: Access invoices data via API

hershyH — Thu, 02 Nov 2023 19:07:26 GMT

Im having the same issue i need to access invoice data as well as create invoices is there any selution yet

Re: Access invoices data via API

Ignazio — Fri, 03 Nov 2023 08:23:20 GMT

Hi @hershyH, nice to meet you. HubSpot support suggested us to do it via CRM cards but it seems it doesn't work. I'm in contact with them and will update you here!

Re: Access invoices data via API

CharlieL — Thu, 30 Nov 2023 00:15:42 GMT

Hi @Ignazio, did you end up finding a solution? Thanks!

Re: Access invoices data via API

hershyH — Thu, 30 Nov 2023 00:50:37 GMT

I recently had a talk with HubSpot as of now there is no API to do this but they are working on one to come out somewhere next year

Re: Access invoices data via API

Ignazio — Thu, 30 Nov 2023 11:47:21 GMT

Hi @CharlieL and @hershyH! Thank you for joining the conversation 🙂

I must clarify one point regarding my scenario. The invoices in my HubSpot account come from an integration with QuickBooks (QBO). This integration also uses HubSpot's "CRM Card" functionality to work.

Keeping this in mind, I just received this reply from the support:

"There currently is no functionality available to get invoices through our API directly. The reason is the CRM Card invoice function uses a third-party's API and webhooks to pull the data into HubSpot. The data isn't actually stored within HubSpot.

In the case of the QBO invoice CRM Card the invoice we link to is pulled directly from QBO (the source of the invoice file/record) and not stored in HubSpot. You could use QBO's API to GET the invoice by ID. The team have heard this feedback and is aware this is a customer painpoint."

Hope this will help you too!

Re: Access invoices data via API

CharlieL — Thu, 14 Dec 2023 17:23:20 GMT

Thank you Ignazio for taking the time to post the response you got in this thread!

It seems we are using the exact same integration. While it is too bad that the information isn't available by API, it makes perfect sense once you know that it isn't actually stored in HS but actually pulled live from QBO.

Thanks again!

Re: Access invoices data via API

Ignazio — Fri, 15 Dec 2023 11:29:28 GMT

Hi @CharlieL!

Thank you for beying part of the conversation and for your help 🙂

If my last comment was helpfull for you, please mark it as a solutions for the other users too.

Re: Access invoices data via API

AArseni6 — Wed, 21 Feb 2024 11:46:24 GMT

Hey there! Has this been resolved in the meantime? Any ideas?

Re: Access invoices data via API

RSchweighart — Wed, 21 Feb 2024 22:00:14 GMT

Hi @Ignazio,

I know this isn't a great solution, but it's been a nice workaround while waiting for the API enpoints to get built. If you go to the invoices page and export all invoices, you could paste into something like a Google Sheet and use Zapier's new/updated row trigger. Then, you can use looping to go through all new/updated rows. This is a solution I set up to sync invoices from HubSpot to Xero. Right now, the marketplace integration only goes from Xero to HubSpot.

If anyone is interested in learning more about the HubSpot to Xero zap I mentioned, just send me an email: ryan@whimpact.co

I haven't set this up but there's also the ability to trigger a workflow in HubSpot from invoice properties such as Status = "Paid". This might solve some use cases for people too.

Best,

Ryan Schweighart

Whole Hart Impact, LLC

whimpact.co

I help businesses with HubSpot and Zapier.

Re: Access invoices data via API

PatOfCle — Mon, 11 Mar 2024 17:31:22 GMT

Invoicing is such a fundamental function and a prime need for integrations. The API should totally include access to the invoice object, which already exists.

Something I don't understand is why they would allow line items to be created via the API but not invoices. Totally inconsistent on Hubspot's part.

If anyone does find a fix for this, would be much appreciated; doing an integration myself right now. I can create line items without a problem, but linking them to a parent invoice does not seem like an option via the api. Any help would be appreciated.

Re: Access invoices data via API

kristinaP — Mon, 11 Nov 2024 16:06:22 GMT

Any updates on this? We have a client working on an integration project who would benefit greatly from the ability to create & update invoices via the API (right now it is read only).

Re: Access invoices data via API

Jaycee_Lewis — Wed, 13 Nov 2024 19:10:08 GMT

Hey @kristinaP 👋 I found a Private Beta for creating invoices via the API. It may be available in either your portal or your customer's portal. Because it is a Private Beta, portals will need to request access and then be approved by the owning product team:

I hope this helps! — Jaycee

cc: @Ignazio @PatOfCle @RSchweighart @AArseni6

Re: Access invoices data via API

Ignazio — Thu, 14 Nov 2024 08:04:43 GMT

Hi and thank you so much for sharing!

Our problem is to get data from invoices, not to create them: that API library will not help 😞

There’s still not a solution at the moment since, as i discovered during these months, invoices are not a fully functional object in HubSpot (so they are limited in functions)

Re: Access invoices data via API

AArseni6 — Thu, 14 Nov 2024 09:27:29 GMT

Hey! Thanks! Great to hear that! 😎What I need is to pull the invoices from an ERP and transfer them over to Hubspot and it seems to cover this scenario. I will see if this beta object can handle this part. Thank you for looking into it! I've requested access and I will see how it goes.