Request for Help Regarding Xero API - How to Use "where" To Find a Contact in Xero

Coffee Lounge
#1

Hey there anyone who has linked to Xero…
(@sitestreet, @scalaris, @Roney_Dsilva and others…)

I’m implementing my Xero API, and I want to be able to search Xero to see if a particular contact already exists to associate an invoice with… and I can’t seem to make the where filter work.

Here is what I have… am I missing some small but important detail? It is just returning all contacts, rather than the one I want…

xero_where

Name.Contains%28%22Peter%22%29

xero_where_manual
xero_where_manual1262×977 63.3 KB

#2

Don’t use this API. Sorry can’t help

#3

Did you find the solution?

#4

No!

#5

@Antony, it looks like you may be putting the where in the wrong place. It’s not a header, it’s a query parameter.

So if you’re doing this in an API action, then you probably need to use the Query Parameters section
image

If that doesn’t work then you could try to use the Dynamic Attributes to set the URL.
Here’s an example
image

So for you it’ll be something like:
https://api.xero.com/api.xro/2.0/Accounts?where={{where_filter}}