How can I get all the records of a query through the api?
Eliminating the limit of 5000 records.
Hi
Have you tried specifying $top
query parameter in your request URI?
Eg:
https://<host>:<port>/int/ifsapplications/projection/v1/CustomerOrderLinesHandling.svc/Reference_CustOrdCust1?$top=20
For instance, above will return top 20 records.
You can see available query parameters from API Doc and you can access API Doc via API Explorer window in Aurena.
Hope this helps!
Hello
- First, you need to go to the API Explorer window and enable the ' Include in Compatibility Application Type' into 'Yes' for the relevant API.
- Then you will be able to open the API Documentation.
- From the documentation, find the handler, and there will be the GET method.
For more details, you can check the below link.
Hope this will helps you.
/Banuka.
Hi,
Hello
- First, you need to go to the API Explorer window and enable the ' Include in Compatibility Application Type' into 'Yes' for the relevant API.
- Then you will be able to open the API Documentation.
- From the documentation, find the handler, and there will be the GET method.
For more details, you can check the below link.
Hope this will helps you.
/Banuka.
Thought it would be worth adding following info as well to
Enabling compatibility application type as above, exposes the projection to be used with basic authentication. By default, only projections of Integration category are exposed through basic authentication.
For projections that do not have this enabled by default, it should be done selectively when OAuth is not an option and after carefully considering the network security as well. Basic authentication is a legacy technology and does not meet current security or compliance requirements, therefore it is advised to use OAuth as much as possible. As far as I know, In IFS Cloud, basic authentication is planned to be removed for APIs.
You can find this in following documentation as well:
Hope this helps!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.