Hi Professionals I am definitely not a professional but work NetSuite Professionals #general

Hi Professionals! I am definitely not a profession...

Owen McCrink

05/08/2024, 1:21 AM

Hi Professionals! I am definitely not a professional, but working on an integration with NetSuite for a project. Got the REST API tutorial working nicely, and can grab invoice and customer data. But I cannot figure out how to filter the endpoint

Copy code

{{REST_SERVICES}}/record/v1/invoice

for a customer (entity) via the q filter. I thought

Copy code

{{REST_SERVICES}}/record/v1/invoice?q=entity EQUAL '2831669'

would work, or entityid or entity.id- but no love. Appreciate any guidance. Assume it should be easy but as new to NetSuite... no luck! (posted here: https://netsuiteprofessionals.com/blog/question/filter-invoices-by-customer-entity-on-rest-api/)

battk

05/08/2024, 2:44 AM

you are using the equal query operator

battk

05/08/2024, 2:44 AM

which is used for numbers

battk

05/08/2024, 2:44 AM

and then comparing it to a string (which is supposed to be double quotes)

battk

05/08/2024, 2:47 AM

use numbers with number type query operators

Owen McCrink

05/08/2024, 5:08 AM

thanks @battk, have also used: IS CONTAINS EQUAL https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_1545222128.html

Owen McCrink

05/08/2024, 5:09 AM

double quote marks.. that gets a different error {{REST_SERVICES}}/record/v1/invoice?q=entity IS "2831669" "detail": "Invalid search query. Detailed unprocessed description follows. Search error occurred: Operator IS is not valid for given search filter.",

Owen McCrink

05/08/2024, 5:10 AM

but... now... {{REST_SERVICES}}/record/v1/invoice?q=entity EQUAL "2831669" Works!

Owen McCrink

05/08/2024, 5:10 AM

so your suggestion of ' vs " works - we got there 😄

5 Views

Open in Slack

Previous Next