hclleapforum

Open full view…

Dynamic Services

yotismitsicosta
Mon, 30 Nov 2020 22:44:35 GMT

Hi everyone, I'm trying to replicate the dynamic service for an app that has now over thousands of results displayed on a table. Since it's getting too big I would like to limit the results of that service. https://hclwiki.atlassian.net/wiki/spaces/HL/pages/461525/Dynamic+Services+-+Leap+REST+API but unfortunately I'm getting the same error message once I change the URL with my organization URL "The request could not be completed. Check you have entered a valid URL and try again." Is there anything I'm missing in the URL? URL: ----- https://<server:port>/forms/secure/org/app/<app id>/<form id>?F_Date1__between=2020-11-01T04:00:00ZA*N*D2020-11-30T05:00:00Z

christopher_dawes
Thu, 17 Dec 2020 16:36:58 GMT

The between operator is tricky to use because the dates have to be in exactly the correct format or it fails (we need to make this easier to use). This URL worked for me: http://localhost:9082/apps/secure/org/data/17be7060-78c8-4b52-85f9-c4f537b7a8b5/F_Form1?creation_time__between=2020-07-15%2008%3A00%3A00.0A*N*D2020-07-18%2008%3A00%3A00.0&sortBy=lastUpdated&order=DESC&draft=false&format=application%2Fx-msexcel&filename=F_Form1.xls&tzOffset=-28800 I would recommend formatting your dates as I have.