Page 1 of 1

Filter API List response?

Posted: Sat Dec 30, 2017 9:59 pm
by 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


Filter API List response?

Posted: Tue Jan 02, 2018 5:50 pm
by 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...


Filter API List response?

Posted: Wed Jan 03, 2018 2:19 pm
by 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?


Filter API List response?

Posted: Wed Jan 03, 2018 4:13 pm
by 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.