Filter API List response?

[Mike Hobbs]

Query an API list. I am working with a 3rd party API to retrieve a list of jobs from the database. When testing the GET /jobs? API I receive a huge list of "jobs" but I only want to return a list that is "assignedTo" a particular person, or a certain workStation or even if the job is "active":TRUE ? Is this possible to do with API express? Is their a tutorial to show how to filter or use parameters? Thanks for the help

[Serhii Kulibaba]

Hello Mike,

Does that server support such a filter? Or you want to filter results on the API Express side?

You can add that filter to the JavaScript component of the API Express service: https://docs.appery.io/docs/apiexpres...

[Mike Hobbs]

Yes - from what I am seeing I could use the script feature on the API Express.

So I'm returning an array of /jobs?

Each job is assigned to a "workFlowStage"

1. Is it possible to return a list of jobs that are assigned to a workflow stage and leave out the ones that are null.

2. Is it possible to create a dynamic list from the workflow stages so that it populates the list with the stage names? Example: If there is 6 jobs in "welding" and 5 jobs in "paint" and 3 jobs in "final assembly"

   So the list would look like;
   welding
   paint
   final assembly

   Then click on one of those stage names to see the jobs assigned to that stage?

   Anyone out there that could help write a javascript snipit to accomplish this?

[Serhii Kulibaba]

If you want us to help you debug the app or write a custom code, please consider purchasing the Advisory Pack service: http://appery.io/service. This service includes app debugging as well as any other custom app help. If this particular issue turns out to be an Appery.io bug, we will credit back the hours spent on this issue and you will be able to use them toward another issue.