Page 1 of 1

List Jobs API - Filtering Jobs

Posted: Wed Dec 11, 2024 6:49 am
by pushkalmadaan
Hi Team,

Is it possible to filter jobs on basis of time along with date?

06/12/2024 13:00 to 06/12/2024 16:00

/api/v1.0/companies/4/jobs/

"errors": [
{
"path": "/DateModified",
"message": "Invalid search value.",
"value": "between(2024-12-05,2024-12-07T15:30:00 10:00)"
}
]

"errors": [
{
"path": "/DateModified",
"message": "Invalid search value.",
"value": "between(2024-12-05 13:00,2024-12-07 14:00)"
}
]

I have tried using time with between, ge and le also but it didn't work out. Please help.

Also is it possible to fetch jobs on basis of multiple Customer.ID instead of one?

"errors": [
{
"path": "/Customer/ID",
"message": "Invalid search value.",
"value": "7002,7419"
}
]

"errors": [
{
"path": "/Customer/ID",
"message": "Invalid search value.",
"value": "eq(7002,7419)"
}
]

Thanks
Pushkal

Re: List Jobs API - Filtering Jobs

Posted: Fri Dec 13, 2024 2:01 am
by SimproAPITeam
Hi pushkalmadaan,
To search for jobs having different Customer id's try this parameter:

Code: Select all

/jobs/?Customer.ID=in(4095,1394)

For the date modified it only supports the date when searching between two different dates.

Code: Select all

jobs/?DateModified=between(2024-11-01,2024-12-31)
Regards

Re: List Jobs API - Filtering Jobs

Posted: Sat Dec 14, 2024 11:33 am
by pushkalmadaan
Hi Team,

Thanks for response!!

Is their any other way to exclude jobs which were not updated in last hour?

We need all jobs updated to particular status but not updated in last hour must be before that only.

Thanks
Pushkal

Re: List Jobs API - Filtering Jobs

Posted: Fri Dec 27, 2024 2:54 am
by SimproAPITeam
Hi pushkalmadaan,

https://developer.simprogroup.com/apido ... -resources

we can't filter by hour. only by day.

eg:

Code: Select all

jobs/?DateModified=le(2024-12-27)
You can submit an idea through our product portal here if you think we should implement it:
https://helpguide.simprogroup.com/Conte ... portal.htm

Thanks