Filtering data from an API call

Need help APIs
1

Hi,

I have an API call.
It is hitting a database with a lot of data.
I want to filter it out before I do anything with the data, as the call often times out.

Below is a screenshot of the API call.

image
image1207×666 54.3 KB

The call is working. It is extracting the data. But the filtering isn’t working.

I have a parameter, whereby the primary_drug_id field should be equal to 641.
This is what I would like to filter. I only want to include data where the primary_drug_id=641.

Any help would be massively appreciated.

Thanks.

Cheers,
Brock.

2

filter it from your repeating group and not from the api connector

3

Thanks, mate.
Is there any tutorial on doing that?

4

filter
filter734×339 22.7 KB

5

So simple.
Thanks.

In terms of the API call itself. Is there a way to stop it from timing out? I just get an unresponsive page error message and have to close the page:
image

It’s quite annoying, because I just quickly reinitialize the call.

6

take off everything after application/json