Thu, 24 Sep 2026
Login

API builder list query with filter

Confluence User - 01 Sep, 2020

 I have a datalist that contains field named myID containing 100 record from 1 to 100

I used api builder to make an API for this datalist it retrieved all data correctly but when I pass a filter field the result is no data even if the data is appeared in datalist
api link : jw/api/datalistname?myId=4

This returns empty data but the datalist contains id 4 I also tried the URL Request Parameter (property in FIlters in datalist)

api link : jw/api/datalistname?myId=4

also retrieved empty data

api;datalists;plugins;filters

2

Confluence User •
02 Sep, 2020 •
confluenceUser •
•
confluenceUser •

Hi, i help tested with a showcase app with url `http://localhost:8080/jw/api/list/list_calendarMeeting?d-6555518-fn_name=Meeting` and it seems to return data correctly. Do you have more specify steps?

btw, i noticed your url is missing `/list`.

Confluence User •
04 Sep, 2020 •
confluenceUser •
•
confluenceUser •

Hi

How many record your datalist retrieve and what is the pagesize configured in it

If pageSize>records retrieved or if  it will works normally

if your data is 100 record and pageSize = 10 it will search only the first 10 records

I also tried to retrieve all data(without filter) it will retrieve only the first n(pageSize) records

when I increased the pageSize to 10000 from datalist properties it works but if I pass the pagesize as parameter it will not retrieve any record

http://localhost:8080/jw/api/list/list_calendarMeeting?d-6555518-fn_name=Meeting&pageSize=2000

1
CSV | Excel | XML | PDF
RELATED QUESTIONS
API Connection Joget DX9
How to trigger workflow process when form data is submitted via API
Plugin for PDF Editor
Can I make list that read the Running Processes ? I want to add my own list and not using the list in monitor
Can I make list that read the Running Processes ? I want to add my own list and not using the list in monitor
403 issue on JSON API call
How to customize datalist process formatter
Please help me fix the problem. The text field is pulling data from a datalist with more than 50k records and the browser hangs.
Please help me fix the problem. The Pop up select box is pulling data from a datalist with more than 50k records and the browser hangs.
How do I authenticate to an external API?
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print