simPRO API Forum

Posted: **Fri Jan 14, 2022 10:41 am**

Is there a way to only get the results from a search where the customfield value is blank or when nothing is selected from a list?

I've tried

Code: Select all

companies/0/jobs/?CustomFields.CustomField.ID=32&CustomFields.Value=
companies/0/jobs/?CustomFields.CustomField.ID=32&CustomFields.Value=0
companies/0/jobs/?CustomFields.CustomField.ID=32&CustomFields.Value=''
companies/0/jobs/?CustomFields.CustomField.ID=32&CustomFields.Value=""
companies/0/jobs/?CustomFields.CustomField.ID=32&CustomFields.Value=null
companies/0/jobs/?CustomFields.CustomField.ID=32&CustomFields.Value=Not+Selected

and all come back empty

Ta,
Ian

Posted: **Sun Jan 16, 2022 10:29 pm**

Thanks for your posting, it seems to be an issue within API, We will work on it and try to release a patch in upcoming release. Will let you know when its out.

Posted: **Tue Dec 19, 2023 3:48 am**

where does the customField id come from? the custom Feild of interest in this case is called "KPIN"

i can get some info containing the customField id using the following but cannot seem to use ?CustomFields.CustomField.ID=KPIN
https://<company>.simprosuite.com/api/v1.0/companies/",0,"/sites/",<id>,"/?columns=CustomFields

Posted: **Tue Dec 19, 2023 3:51 am**

Will this allow me to get the site information using the value in KPIN e.g. 7702?

Posted: **Tue Dec 19, 2023 4:42 am**

Hi Casey,
You can find the custom field ID's in the setup section of the API.

See here for different kind of custom fields and their setup. For example, if you have custom field #4 set up for jobs all jobs will have custom field 4, but with different values stored. You can then query the value in the custom field ID.

https://developer.simprogroup.com/apido ... 385e9fb6f0

Regards

simPRO API Forum

Search on CustomField value "Not Selected"

Search on CustomField value "Not Selected"

Re: Search on CustomField value "Not Selected"

Re: Search on CustomField value "Not Selected"

Re: Search on CustomField value "Not Selected"

Re: Search on CustomField value "Not Selected"