List Jobs API - Filtering Jobs

[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

[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

[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

[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