Filtering issuedDocuments on entity.id

[grasflorian]

Hello,

I'm facing an unexpected behaviour when trying to filter issuedDocuments on the entity.id field. I'm trying to filter out issuedDocuments for which the client/supplier was set through the research in authorized databases. In such cases I noticed that the entity.id was not set and tried to add the filter entity.id != null and entity.id <> null however the issuedDocument is still returned.

Example query (using <>):

curl -X GET https://api-v2.fattureincloud.it/c/<company_id>/issued_documents?page=1&per_page=50&fieldset=detailed&sort=-id&type=invoice&q=entity.id+%3C%3E+null

I also noticed that using entity.id = null works as expected, returning only the issuedDocuments I was looking for.

Am I using the filter wrong? Or maybe it's just not possible to filter these out?

Thanks in advance.

[ethanalan786]

Hi, can I know that in which language you are trying to access this? Python/VBA/Javascript/...

[ethanalan786]

I was working with JavaScript in Google Sheets. I tried that approach as well, but it didn’t work for me. So, I retrieved the full dataset and, in JavaScript, filtered it by checking which records contain entity.id and removed the blank ones. That worked for me.

[grasflorian]

Hey, answering your question here as well. I'm using Python to process the data. In the end, what works as expected (entity.id = null) is sufficient for my scope. So I ended up using only that for my use-case. I would have done the same as you in the meantime if I needed to filter them out.

In any case, I just wanted to point out what I consider an unexpected behaviour of the API.