# REST API **URL:** https://community.dreamfactory.com/c/rest-api/13.md [Latest](https://community.dreamfactory.com/latest.md) · [Categories](https://community.dreamfactory.com/categories.md) · [Tags](https://community.dreamfactory.com/tags.md) --- ## [About the REST API category](https://community.dreamfactory.com/t/about-the-rest-api-category/20)
**Author:** [@benbusse](https://community.dreamfactory.com/u/benbusse)\ **Replies:** 0
This category is about the DreamFactory REST API. --- ## [I Need Strategies for Optimizing API Performance in DreamFactory](https://community.dreamfactory.com/t/i-need-strategies-for-optimizing-api-performance-in-dreamfactory/5551)
**Author:** [@sparkles](https://community.dreamfactory.com/u/sparkles)\ **Replies:** 1\ **Last updated:** [May 9, 2025, 10:25am UTC](https://community.dreamfactory.com/t/i-need-strategies-for-optimizing-api-performance-in-dreamfactory/5551 "2025-05-09T10:25:16Z")
Hey everyone, :smiling\_face\_with\_three\_hearts: I am a big fan of DreamFactory here! I’ve been using it for a while now, and I love its flexibility and all the features it offers. However, as my application scales up, I… --- ## [How to Use DreamFactory REST API Custom Authentication](https://community.dreamfactory.com/t/how-to-use-dreamfactory-rest-api-custom-authentication/5561)
**Author:** [@jarethdf](https://community.dreamfactory.com/u/jarethdf)\ **Replies:** 0\ **Last updated:** [August 21, 2024, 12:56pm UTC](https://community.dreamfactory.com/t/how-to-use-dreamfactory-rest-api-custom-authentication/5561 "2024-08-21T12:56:11Z")
Hi there, I am working on a project that utilizes DreamFactory to manage our REST API endpoints & I need some guidance on implementing custom authentication methods; Our use case requires integrating a third party authe… --- ## [Which Is The Best For Hotel Industry?](https://community.dreamfactory.com/t/which-is-the-best-for-hotel-industry/5415)
**Author:** [@Neha890](https://community.dreamfactory.com/u/Neha890)\ **Replies:** 4\ **Last updated:** [June 21, 2024, 5:08am UTC](https://community.dreamfactory.com/t/which-is-the-best-for-hotel-industry/5415 "2024-06-21T05:08:33Z")
Has anyone used a hotel API? I’m building a hotel booking application, I require APIs that provide accurate data related to pricing, reviews, rooms, and more! --- ## [Case Insensitive Search Not working in V4.8.0](https://community.dreamfactory.com/t/case-insensitive-search-not-working-in-v4-8-0/5486)
**Author:** [@Anuragverma](https://community.dreamfactory.com/u/Anuragverma)\ **Replies:** 1\ **Last updated:** [July 29, 2023, 6:09am UTC](https://community.dreamfactory.com/t/case-insensitive-search-not-working-in-v4-8-0/5486 "2023-07-29T06:09:13Z")
How to use the case insensitive search in GET API calls in ver 4.8.0 as it is not working. --- ## [Testing purpose](https://community.dreamfactory.com/t/testing-purpose/5467)
**Author:** [@account2](https://community.dreamfactory.com/u/account2)\ **Replies:** 0\ **Last updated:** [May 6, 2023, 5:28pm UTC](https://community.dreamfactory.com/t/testing-purpose/5467 "2023-05-06T17:28:42Z")
sdxfcvghjertfgyhujikodrftgyhujfrtgyhjktgyhjt6yu --- ## [Limit pagination json return](https://community.dreamfactory.com/t/limit-pagination-json-return/3442)
**Author:** [@Nova\_Cloud](https://community.dreamfactory.com/u/Nova_Cloud)\ **Replies:** 3\ **Last updated:** [October 4, 2022, 1:52am UTC](https://community.dreamfactory.com/t/limit-pagination-json-return/3442 "2022-10-04T01:52:32Z")
Hello, using dreamfactory with mysql. When I make the request http://api-u16.cloudapp.net/api/v2/nova207/\_table/clients My return json is limited to 1000 records. How to increase this return to 1500 records? --- ## [REST API request parameter value = 0 issue](https://community.dreamfactory.com/t/rest-api-request-parameter-value-0-issue/5413)
**Author:** [@Vipin\_123](https://community.dreamfactory.com/u/Vipin_123)\ **Replies:** 1\ **Last updated:** [September 28, 2022, 10:27am UTC](https://community.dreamfactory.com/t/rest-api-request-parameter-value-0-issue/5413 "2022-09-28T10:27:17Z")
I am trying GET method with request parameters, Whenever I am trying to send request with request parameter value as 0 it consider it as null/empty once the request is forwarded to my application. If you pass parameter … --- ## [PUT request for MySQL DB returns "The request contains no valid record fields."](https://community.dreamfactory.com/t/put-request-for-mysql-db-returns-the-request-contains-no-valid-record-fields/5358)
**Author:** [@Floh](https://community.dreamfactory.com/u/Floh)\ **Replies:** 1\ **Last updated:** [March 6, 2022, 11:34am UTC](https://community.dreamfactory.com/t/put-request-for-mysql-db-returns-the-request-contains-no-valid-record-fields/5358 "2022-03-06T11:34:20Z")
This is the body of my PUT request. I’m using /\_table/{table\_name}/{id}, and my headers work properly when doing a GET request. { "resource": \[ { "id": 1, "active": false, } \] } This is my table, the a… --- ## [Stored procedure with count of records](https://community.dreamfactory.com/t/stored-procedure-with-count-of-records/5260)
**Author:** [@Gael](https://community.dreamfactory.com/u/Gael)\ **Replies:** 3\ **Last updated:** [October 20, 2021, 10:05am UTC](https://community.dreamfactory.com/t/stored-procedure-with-count-of-records/5260 "2021-10-20T10:05:19Z")
Hi is there a way to get a records count when calling a stored procedure ? Like an include\_count parameter. As a workaround, the stores procedure returns 2 result sets : one with data, the second with a count of record… --- ## [Versioning API best practice?](https://community.dreamfactory.com/t/versioning-api-best-practice/455)
**Author:** [@AtlasApollo](https://community.dreamfactory.com/u/AtlasApollo)\ **Replies:** 12\ **Last updated:** [June 26, 2021, 10:26am UTC](https://community.dreamfactory.com/t/versioning-api-best-practice/455 "2021-06-26T10:26:21Z")
Hi. I am wondering, if I create an API definition for version 1 of my app, and then want to make changes in future versions without breaking v1 clients, how would I version it? One way I imagine this could be done, … --- ## [Authorization accepted but I cannot have the token and nor the APi key](https://community.dreamfactory.com/t/authorization-accepted-but-i-cannot-have-the-token-and-nor-the-api-key/5293)
**Author:** [@zion](https://community.dreamfactory.com/u/zion)\ **Replies:** 3\ **Last updated:** [May 30, 2021, 1:51pm UTC](https://community.dreamfactory.com/t/authorization-accepted-but-i-cannot-have-the-token-and-nor-the-api-key/5293 "2021-05-30T13:51:33Z")
Hi, I’m a Df beginer and C# newbie, however I have to connect to a DF rest and send files, I succeed to log in but the response from the HttpRequest doesnt show any “token”, I must precise that I did not produce the APi… --- ## [Android Exception when Rest API managed by DreamFactory](https://community.dreamfactory.com/t/android-exception-when-rest-api-managed-by-dreamfactory/5299)
**Author:** [@Ecologic-DSI](https://community.dreamfactory.com/u/Ecologic-DSI)\ **Replies:** 1\ **Last updated:** [May 28, 2021, 10:00am UTC](https://community.dreamfactory.com/t/android-exception-when-rest-api-managed-by-dreamfactory/5299 "2021-05-28T10:00:35Z")
Hi I’m developing an Android mobile App with delphi using a Rest API hosted by an Apache server. Everything was working perfectly until I place DreamFactory between clients and Rest API server. I implemented Service, … --- ## [Using an array as a parameter to a procedure](https://community.dreamfactory.com/t/using-an-array-as-a-parameter-to-a-procedure/5297)
**Author:** [@NolsSmit](https://community.dreamfactory.com/u/NolsSmit)\ **Replies:** 0\ **Last updated:** [May 20, 2021, 2:22pm UTC](https://community.dreamfactory.com/t/using-an-array-as-a-parameter-to-a-procedure/5297 "2021-05-20T14:22:24Z")
Hi, I’ve created a PostgreSQL function which use an array as the second parameter. The first parameter is used for free text search. Each array column in the second parameter either refers to a lookup table or to a pr… --- ## [Calling Oracle Stored Procedure with an OUT parameter](https://community.dreamfactory.com/t/calling-oracle-stored-procedure-with-an-out-parameter/5251)
**Author:** [@timbouffard](https://community.dreamfactory.com/u/timbouffard)\ **Replies:** 1\ **Last updated:** [December 1, 2020, 5:47pm UTC](https://community.dreamfactory.com/t/calling-oracle-stored-procedure-with-an-out-parameter/5251 "2020-12-01T17:47:25Z")
Calling the POST execute procedure api. I have an oracle stored procedure with two parameters. One parameter is an IN parameter and the other parameter is an OUT parameters. CREATE OR REPLACE PROCEDURE up\_test\_out (p\_i… --- ## [No 'Access-Control-Allow-Origin' header is present on the requested resource](https://community.dreamfactory.com/t/no-access-control-allow-origin-header-is-present-on-the-requested-resource/4263)
**Author:** [@drexelsharp](https://community.dreamfactory.com/u/drexelsharp)\ **Replies:** 4\ **Last updated:** [November 27, 2020, 2:52pm UTC](https://community.dreamfactory.com/t/no-access-control-allow-origin-header-is-present-on-the-requested-resource/4263 "2020-11-27T14:52:06Z")
DreamFactory Version: 2.11.0 trying to open CORS up to allow everything for development. I’ve added an asterisk on Path, Origins, Headers. Selected all methods. checked Enabled and Supports Credentials. I am still rece… --- ## [DreamFactory Utility Module: Could not find driver for Firebird 3 - Follow up](https://community.dreamfactory.com/t/dreamfactory-utility-module-could-not-find-driver-for-firebird-3-follow-up/5247)
**Author:** [@NolsSmit](https://community.dreamfactory.com/u/NolsSmit)\ **Replies:** 0\ **Last updated:** [November 6, 2020, 3:50pm UTC](https://community.dreamfactory.com/t/dreamfactory-utility-module-could-not-find-driver-for-firebird-3-follow-up/5247 "2020-11-06T15:50:30Z")
I followed these steps: Start with: $ sudo apt-get update Install php $ sudo apt install php7.4-cli Install php dev $ sudo apt install php7.4-dev cd /tmp git clone https://github.com/php/pecl-database-interbase.g… --- ## [Ionic Framework Trouble](https://community.dreamfactory.com/t/ionic-framework-trouble/2412)
**Author:** [@Declan\_Murphy](https://community.dreamfactory.com/u/Declan_Murphy)\ **Replies:** 1\ **Last updated:** [March 25, 2016, 2:52pm UTC](https://community.dreamfactory.com/t/ionic-framework-trouble/2412 "2016-03-25T14:52:25Z")
So far this is the only (DF related) code I have entered: var todoApp = angular.module('starter', \['ionic', 'ngDreamFactory'\], function ($compileProvider) { .constant('DSP\_URL', 'https://\*\*\*\*\*\*\*\*\*\*/api/v2') .cons… --- ## [Get records by post](https://community.dreamfactory.com/t/get-records-by-post/4647)
**Author:** [@mimu](https://community.dreamfactory.com/u/mimu)\ **Replies:** 0\ **Last updated:** [October 11, 2018, 4:46pm UTC](https://community.dreamfactory.com/t/get-records-by-post/4647 "2018-10-11T16:46:43Z")
in this post is a description about getting filtered records by post: for example: curl -X POST ‘https://dsp-mydspname.cloud.dreamfactory.com/rest/mongo/zipcodes?limit=3&fields=city%2Cstate%2CPopulationOver40’ -H… --- ## [File explorer icon is not showing after i created the new application](https://community.dreamfactory.com/t/file-explorer-icon-is-not-showing-after-i-created-the-new-application/990)
**Author:** [@pshapur123](https://community.dreamfactory.com/u/pshapur123)\ **Replies:** 1\ **Last updated:** [April 13, 2015, 3:16pm UTC](https://community.dreamfactory.com/t/file-explorer-icon-is-not-showing-after-i-created-the-new-application/990 "2015-04-13T15:16:29Z")
I created the new app but file explorer icon is not showing the for the app due to this reason not able to modify soruce code of the application. I installed DreamFactory version is 1.9.1 --- ## [Can we able to access Email servers(IMAP, SMTP, POP3) For Mobile App?](https://community.dreamfactory.com/t/can-we-able-to-access-email-servers-imap-smtp-pop3-for-mobile-app/949)
**Author:** [@k\_veeranki](https://community.dreamfactory.com/u/k_veeranki)\ **Replies:** 2\ **Last updated:** [March 30, 2015, 4:37pm UTC](https://community.dreamfactory.com/t/can-we-able-to-access-email-servers-imap-smtp-pop3-for-mobile-app/949 "2015-03-30T16:37:33Z")
I want to do an Email Client App Using PhoneGap. For that... Basically For Any Email Client Application We can able to hit Remote Servers. They are.. IMAP POP3 SMTP Servers with their Host Protocols and Port nu… --- ## [How use postgres function in dreamfactory](https://community.dreamfactory.com/t/how-use-postgres-function-in-dreamfactory/1025)
**Author:** [@gerframen](https://community.dreamfactory.com/u/gerframen)\ **Replies:** 2\ **Last updated:** [April 23, 2015, 3:18pm UTC](https://community.dreamfactory.com/t/how-use-postgres-function-in-dreamfactory/1025 "2015-04-23T15:18:51Z")
I need use psotgres function with IN/OUT params Please helpme, in spanish... --- ## [HTTP service not working](https://community.dreamfactory.com/t/http-service-not-working/5201)
**Author:** [@lakshay](https://community.dreamfactory.com/u/lakshay)\ **Replies:** 3\ **Last updated:** [July 8, 2020, 4:48pm UTC](https://community.dreamfactory.com/t/http-service-not-working/5201 "2020-07-08T16:48:05Z")
I have created 2 HTTP service for a single micro service, both in different environment and using different dream factory version respectively:- bitnami-dreamfactory-2-14-1-13-linux-debian-9-x86-64 bitnami-dreamfactory… --- ## [API docs not rendering for a user with a role with a single Oracle table](https://community.dreamfactory.com/t/api-docs-not-rendering-for-a-user-with-a-role-with-a-single-oracle-table/5204)
**Author:** [@nfz11](https://community.dreamfactory.com/u/nfz11)\ **Replies:** 0\ **Last updated:** [July 6, 2020, 12:24pm UTC](https://community.dreamfactory.com/t/api-docs-not-rendering-for-a-user-with-a-role-with-a-single-oracle-table/5204 "2020-07-06T12:24:02Z")
I am experiencing this bug and I am wondering if anyone else has seen it. I have two database services to two different Oracle databases. I created a role with GET access to \_table/\* in one database and \_table/SCHEMA.MY… --- ## [Multiple relationship filtering on a single call](https://community.dreamfactory.com/t/multiple-relationship-filtering-on-a-single-call/4875)
**Author:** [@bledileka](https://community.dreamfactory.com/u/bledileka)\ **Replies:** 1\ **Last updated:** [June 12, 2020, 5:29pm UTC](https://community.dreamfactory.com/t/multiple-relationship-filtering-on-a-single-call/4875 "2020-06-12T17:29:46Z")
Hi everyone, i am new to DF, trying to get around some standard sql queries like: select id from table1 where id IN (select anotherid from table2 where somerules) and id NOT IN (select someotherid from table3 where som… --- ## [How to debug or see logs of custom python script services?](https://community.dreamfactory.com/t/how-to-debug-or-see-logs-of-custom-python-script-services/4964)
**Author:** [@regalartech](https://community.dreamfactory.com/u/regalartech)\ **Replies:** 1\ **Last updated:** [April 20, 2020, 9:20pm UTC](https://community.dreamfactory.com/t/how-to-debug-or-see-logs-of-custom-python-script-services/4964 "2020-04-20T21:20:23Z")
I am using python requests library to reroute the the API which are received by Dreamfactory to another REST service , the response from that service is then again passed through the python custom scripts . but How to d… --- ## [The character encoding of the plain text document was not declared](https://community.dreamfactory.com/t/the-character-encoding-of-the-plain-text-document-was-not-declared/2510)
**Author:** [@m\_menon](https://community.dreamfactory.com/u/m_menon)\ **Replies:** 1\ **Last updated:** [April 16, 2020, 10:19pm UTC](https://community.dreamfactory.com/t/the-character-encoding-of-the-plain-text-document-was-not-declared/2510 "2020-04-16T22:19:04Z")
I have been observing the below message in Firefox console for a while now. I have a Bitnami 2.1 Dreamfactory install. I have tried adding utf-8 charset in ever possible place I could think and find but it simply doesn’t… --- ## [Forgot password API?](https://community.dreamfactory.com/t/forgot-password-api/1236)
**Author:** [@allensandiego](https://community.dreamfactory.com/u/allensandiego)\ **Replies:** 13\ **Last updated:** [March 18, 2020, 9:01pm UTC](https://community.dreamfactory.com/t/forgot-password-api/1236 "2020-03-18T21:01:32Z")
Hi, Looking through the API Documents for the user, I noticed that there was no option for a Forgot Password scenario. Is there any other way we can do this through Rest? Thanks, Allen --- ## [Where to check logs in dreamfactory 2.14](https://community.dreamfactory.com/t/where-to-check-logs-in-dreamfactory-2-14/4978)
**Author:** [@regalartech](https://community.dreamfactory.com/u/regalartech)\ **Replies:** 1\ **Last updated:** [February 27, 2020, 6:47pm UTC](https://community.dreamfactory.com/t/where-to-check-logs-in-dreamfactory-2-14/4978 "2020-02-27T18:47:35Z")
I loved this product. Awesome work. I am trying to find the log files . I found one in the files but that does not have the fail logs of say \_table API or other default API . Note : I am using my custom build of dreamfa… --- ## [Can you use a variable within a LIKE query?](https://community.dreamfactory.com/t/can-you-use-a-variable-within-a-like-query/5128)
**Author:** [@NatSo1](https://community.dreamfactory.com/u/NatSo1)\ **Replies:** 1\ **Last updated:** [February 26, 2020, 10:31pm UTC](https://community.dreamfactory.com/t/can-you-use-a-variable-within-a-like-query/5128 "2020-02-26T22:31:37Z")
I’m using React, and I’m new to it. I want to have the items sort by last name (this works fine), and I want for the user to type into a search box the value of the variable query. This variable query will be used on t… [Next page](https://community.dreamfactory.com/c/rest-api/13.md?page=1)