No expenses in webhooks or Zapier

Self-Hosted | v5
1

I’m in the process of migrating from my Freshbooks account to INSH. All good so far, but there are limitations with expenses for some reason.

I’m using Zapier to do, well, almost everything. And a key point of my flow is to register expenses and invoices to external services (sheets and such).
While the IN Zapier integration works, even if it sends mainly ID for a lot of important stuff like… Currencies! The Expenses are completely missing from it.

So I’m playing with webhooks as there’s the ‘new/updated expense’ trigger I need.
Well, welcome to the IDs Multiverse!!
Everything is sent as an ID, and by everything, I mean the expense category and vendor

Workaround n1: Custom Field(s) - issue, breaks the IN flow as I won’t use the Categories nor the Vendors anymore
Workaround n2 aka the semiworkingsolution: loot table on my end - issue, maintaining yet another thing!

Both are not very practical and I’d like to understand why the expenses are completely missing from Zapier integration, it should be IN APIs right?

Or… am I missing something?

thanks

2

Hi,

Expenses/vendors haven’t been implemented yet in Zapier, it’s on our list for a future release.

If you’re using webhooks you can use the API to resolve ids to their values.

https://api-docs.invoicing.co

3

I was actually going another direction and querying the DB straight… then I noticed the ‘ID’ sent by the webhook are not actual id and are not stored in the db as far as I was able to see.
Expense id in its DB table is ‘2’ but the one sent via webhook is ‘VolejRejNm’ and I wasn’t able to match the two. What am I missing here?

Any potential eta for the Zapier integration? That’s THE only thing that’s missing and seems quite an important one.

I have a client who’s using the hosted IN Pro and same issue there, as expected.

4

We don’t recommend querying the database directly. The id’s are hashed, in the database you’ll see the underlying number whereas in the app/API you’ll see the hashed value.

Sorry, we aren’t able to provide ETAs for future features.

5

Right, at the same time I’m not even able to get the currency zia Zapier, same ID issue… what’s the point on having an integration if I’m only getting unreadable info that I need to re-associate, kind of strange sadly.
I’ll see if there are other options then. Please consider ‘fixing’ the Z app thanks

6

FYI… the id’s for static data is available here:

1 Like
7

Just checking if there has been any progress on this as has been almost a year and the expenses are nowhere to be found in Zapier. Do we have other solutions to automatically CREATE an expense in IN?

8

You may want to consider trying Make, I believe they have better API coverage.

9

Any other options? Zapier is kind of a big player out there… is IN responsible to ‘update’ their integration or someone else is?

10

You can see the full list here: Automations - Free Invoicing Software for Small Businesses | Invoice Ninja

I’m responsible for the Zapier integration.

11

Great, so allow me to request features parity for Zapier :slight_smile: The expenses actions/triggers is the main functionality that’s missing, it would be grand to have it. Happy to test/help if needed if I can

1 Like