# Latest **URL:** https://community.dreamfactory.com/latest.md?page=1 [Latest](https://community.dreamfactory.com/latest.md) · [Categories](https://community.dreamfactory.com/categories.md) · [Tags](https://community.dreamfactory.com/tags.md) **Page:** 2 --- ## [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 … --- ## [Lessons Learned with MS SQL Server](https://community.dreamfactory.com/t/lessons-learned-with-ms-sql-server/230)
**Author:** [@DKL](https://community.dreamfactory.com/u/DKL)\ **Replies:** 1\ **Last updated:** [June 7, 2022, 6:42am UTC](https://community.dreamfactory.com/t/lessons-learned-with-ms-sql-server/230 "2022-06-07T06:42:37Z")
I am using DreamFactory in Azure to connect to a Microsoft SQL Server 2012 that is also running in Azure. I learned a few things today that I thought I would share. First, your Azure SQL Endpoint has both an external … --- ## [Take a Picture of your office set up and what it looks like in your world!](https://community.dreamfactory.com/t/take-a-picture-of-your-office-set-up-and-what-it-looks-like-in-your-world/2694)
**Author:** [@DFCommunityManager](https://community.dreamfactory.com/u/DFCommunityManager)\ **Replies:** 11\ **Last updated:** [May 11, 2022, 9:39am UTC](https://community.dreamfactory.com/t/take-a-picture-of-your-office-set-up-and-what-it-looks-like-in-your-world/2694 "2022-05-11T09:39:34Z")
We have members from all over the world here!, so I'm really curious about your city/country. Where are you? Take a picture of your own place... whether that is your City, Home, Work, in front of your window or wherever … --- ## [Problem to load the configpanel](https://community.dreamfactory.com/t/problem-to-load-the-configpanel/5383)
**Author:** [@MrSpock](https://community.dreamfactory.com/u/MrSpock)\ **Replies:** 0\ **Last updated:** [May 6, 2022, 5:22pm UTC](https://community.dreamfactory.com/t/problem-to-load-the-configpanel/5383 "2022-05-06T17:22:43Z")
Hi, I have used the GitHub Install on Debian 11. The installer does not work (see my previous post here), therefore I manually installed the framework. MongoDB 5.0 cannot be installed due to no AVX support of my proces… --- ## [Debian 11 installer](https://community.dreamfactory.com/t/debian-11-installer/5367)
**Author:** [@MrSpock](https://community.dreamfactory.com/u/MrSpock)\ **Replies:** 0\ **Last updated:** [April 16, 2022, 7:07pm UTC](https://community.dreamfactory.com/t/debian-11-installer/5367 "2022-04-16T19:07:56Z")
Hi, I tried to use the installer from github to install dreamfactory. The system reports that only Debian 9 and 10 are supported. So I looked into the debian.sh file and the comments say that Debian 11 is not yet support… --- ## [DreamFactory on Centos Plesk with Virtual Host](https://community.dreamfactory.com/t/dreamfactory-on-centos-plesk-with-virtual-host/121)
**Author:** [@ikyaqoob](https://community.dreamfactory.com/u/ikyaqoob)\ **Replies:** 9\ **Last updated:** [March 29, 2022, 5:08pm UTC](https://community.dreamfactory.com/t/dreamfactory-on-centos-plesk-with-virtual-host/121 "2022-03-29T17:08:37Z")
Hi How can DreamFactory be installed on a dedicated server running centos with plesk and having virtual host , If it can run on bitnami stack , sure there must be a way to do thanks --- ## [Create record by identifier not currently supported](https://community.dreamfactory.com/t/create-record-by-identifier-not-currently-supported/5361)
**Author:** [@wayne](https://community.dreamfactory.com/u/wayne)\ **Replies:** 0\ **Last updated:** [March 26, 2022, 7:23am UTC](https://community.dreamfactory.com/t/create-record-by-identifier-not-currently-supported/5361 "2022-03-26T07:23:36Z")
Got below error when requesting postman with: https://company.apps.dreamfactory.com/api/v2/Postman/\_table/listings/1##### { “error”: { “code”: 400, “context”: null, “message”: “Create record by identifier not curren… --- ## [MySQL functions like now() in server side filters](https://community.dreamfactory.com/t/mysql-functions-like-now-in-server-side-filters/2744)
**Author:** [@bohndorf](https://community.dreamfactory.com/u/bohndorf)\ **Replies:** 2\ **Last updated:** [June 1, 2016, 8:42pm UTC](https://community.dreamfactory.com/t/mysql-functions-like-now-in-server-side-filters/2744 "2016-06-01T20:42:50Z")
How can I create a server side filter for the following SQL expression in a role?: (startdate=0) or (startdate \<= now()) Trying using a MySQL function as filter value always results in an error "Field 'starttime' must … --- ## [Community Monthly Digest - July 2016](https://community.dreamfactory.com/t/community-monthly-digest-july-2016/2940)
**Author:** [@DFCommunityManager](https://community.dreamfactory.com/u/DFCommunityManager)\ **Replies:** 0\ **Last updated:** [July 1, 2016, 3:39pm UTC](https://community.dreamfactory.com/t/community-monthly-digest-july-2016/2940 "2016-07-01T15:39:46Z")
Hello DreamFactory folks! Glad to see you here. :slight\_smile: Welcome to our July Community digest where we cover the month of June! Stats of the last 30 days We’re over 1,000 members on our community forum! 1,126 … --- ## [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… --- ## [Login to UI - Not allowed in CORS policy](https://community.dreamfactory.com/t/login-to-ui-not-allowed-in-cors-policy/5351)
**Author:** [@twoxim](https://community.dreamfactory.com/u/twoxim)\ **Replies:** 1\ **Last updated:** [March 4, 2022, 2:54pm UTC](https://community.dreamfactory.com/t/login-to-ui-not-allowed-in-cors-policy/5351 "2022-03-04T14:54:08Z")
5 min to install and 12 hrs to login…I’ve reinstalled 3 times via clone from Git and can’t figure out why I’m getting “Not allowed in CORS policy.” I’ve added some version of "Access-Control-Allow-Origin “\*” to: the ap… --- ## [What is the IP address of my API?](https://community.dreamfactory.com/t/what-is-the-ip-address-of-my-api/5333)
**Author:** [@juansg](https://community.dreamfactory.com/u/juansg)\ **Replies:** 0\ **Last updated:** [December 15, 2021, 8:02am UTC](https://community.dreamfactory.com/t/what-is-the-ip-address-of-my-api/5333 "2021-12-15T08:02:19Z")
Hi all, I create API from DreamFactory connected to MySQL on another hosting. My hosting company needs the IP address of this API to grant access-permission for this IP. Please, can you tell me what is the IP address o… --- ## [Attempting to install inside existing Docker Composed environment](https://community.dreamfactory.com/t/attempting-to-install-inside-existing-docker-composed-environment/5331)
**Author:** [@gdh](https://community.dreamfactory.com/u/gdh)\ **Replies:** 0\ **Last updated:** [November 11, 2021, 3:02pm UTC](https://community.dreamfactory.com/t/attempting-to-install-inside-existing-docker-composed-environment/5331 "2021-11-11T15:02:58Z")
I have an existing tech stack of several frontend (angular, react) and backend (Nginx, Python Django, with Redis & Postgresql) and now we want to test DF. In order to conserve resources I do not want to use the Bitnami i… --- ## [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… --- ## [CORS configuration](https://community.dreamfactory.com/t/cors-configuration/5327)
**Author:** [@Someone](https://community.dreamfactory.com/u/Someone)\ **Replies:** 0\ **Last updated:** [September 27, 2021, 2:39pm UTC](https://community.dreamfactory.com/t/cors-configuration/5327 "2021-09-27T14:39:04Z")
I’m trying to configure CORS for selective origin URL. It seems like my CORS is not working fine after configuration. It still allows any anonymous URL to call from. I can see that there is select statement from CORS co… --- ## [Insert failed because set options have incorrect settings SQL Server](https://community.dreamfactory.com/t/insert-failed-because-set-options-have-incorrect-settings-sql-server/5309)
**Author:** [@TimoRick](https://community.dreamfactory.com/u/TimoRick)\ **Replies:** 0\ **Last updated:** [July 7, 2021, 2:49pm UTC](https://community.dreamfactory.com/t/insert-failed-because-set-options-have-incorrect-settings-sql-server/5309 "2021-07-07T14:49:05Z")
we want to insert data to a table using an stored procedure which works as the api endpoint. when running this stored procedure directly in SQLManagementStudio everything works well. but when we using this api-endpoint w… --- ## [Postgresql service with sslmode SSL off](https://community.dreamfactory.com/t/postgresql-service-with-sslmode-ssl-off/5039)
**Author:** [@PhantomSalt](https://community.dreamfactory.com/u/PhantomSalt)\ **Replies:** 1\ **Last updated:** [June 29, 2021, 9:26am UTC](https://community.dreamfactory.com/t/postgresql-service-with-sslmode-ssl-off/5039 "2021-06-29T09:26:39Z")
Hi, I am trying to connect a postgresql db as a service. I can’t seem to get the sslmode option to work. I have tried adding it as an option and in the connection string. The error I get is I have tried ssl and sslmo… --- ## [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, … --- ## [Web application connect to Rest server via local network but not via domain](https://community.dreamfactory.com/t/web-application-connect-to-rest-server-via-local-network-but-not-via-domain/5304)
**Author:** [@NolsSmit](https://community.dreamfactory.com/u/NolsSmit)\ **Replies:** 0\ **Last updated:** [June 21, 2021, 7:47pm UTC](https://community.dreamfactory.com/t/web-application-connect-to-rest-server-via-local-network-but-not-via-domain/5304 "2021-06-21T19:47:09Z")
Hi, Via docker a containers on Ubuntu server, I’m using Dreamfacory for the Rest interfaces to access a Postgres database. The database is also running in a docker container. The server’s local IP address is 192.168.1.… --- ## [Android Client Exception when Rest API managed by DreamFactory (double quote on params)](https://community.dreamfactory.com/t/android-client-exception-when-rest-api-managed-by-dreamfactory-double-quote-on-params/5300)
**Author:** [@Ecologic-DSI](https://community.dreamfactory.com/u/Ecologic-DSI)\ **Replies:** 2\ **Last updated:** [June 1, 2021, 4:54pm UTC](https://community.dreamfactory.com/t/android-client-exception-when-rest-api-managed-by-dreamfactory-double-quote-on-params/5300 "2021-06-01T16:54:01Z")
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, … --- ## [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… --- ## [Import Open API v2 Doc in HTTP service \> DF removes definitions](https://community.dreamfactory.com/t/import-open-api-v2-doc-in-http-service-df-removes-definitions/5301)
**Author:** [@Ecologic-DSI](https://community.dreamfactory.com/u/Ecologic-DSI)\ **Replies:** 0\ **Last updated:** [May 28, 2021, 12:00pm UTC](https://community.dreamfactory.com/t/import-open-api-v2-doc-in-http-service-df-removes-definitions/5301 "2021-05-28T12:00:47Z")
Hi I’m facing to an error during doc import for an HTTP service Doc is a JSON Open API v2 and it’s working fine as swaggerUI from API service provider But when I create service and import doc, DreamFactory convert it … --- ## [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… --- ## [Regarding the security of the DreamFactory Docker Images](https://community.dreamfactory.com/t/regarding-the-security-of-the-dreamfactory-docker-images/5296)
**Author:** [@signum](https://community.dreamfactory.com/u/signum)\ **Replies:** 0\ **Last updated:** [May 13, 2021, 8:47am UTC](https://community.dreamfactory.com/t/regarding-the-security-of-the-dreamfactory-docker-images/5296 "2021-05-13T08:47:17Z")
Hi, I was checking out the community version of the Docker Images for DreamFactory, and noted that when I tried to scan the images after downloading using trivy / “docker scan”, it does seem to show a list of vulnerabili… --- ## [Retrieving by date](https://community.dreamfactory.com/t/retrieving-by-date/4240)
**Author:** [@Sidlegionair](https://community.dreamfactory.com/u/Sidlegionair)\ **Replies:** 1\ **Last updated:** [April 28, 2021, 11:23am UTC](https://community.dreamfactory.com/t/retrieving-by-date/4240 "2021-04-28T11:23:03Z")
Hi, I’m using PHP to filter from a mongodb database and everything seems to work, except when I want to retrieve a date record from it. PHP code: $filterstring .= " AND (createdAt \< ".date\_format(DateTime::createFromF… --- ## [Connecting to MongoDB](https://community.dreamfactory.com/t/connecting-to-mongodb/30)
**Author:** [@Mark](https://community.dreamfactory.com/u/Mark)\ **Replies:** 1\ **Last updated:** [February 24, 2021, 4:46pm UTC](https://community.dreamfactory.com/t/connecting-to-mongodb/30 "2021-02-24T16:46:47Z")
This is a quick guide on how to setup database connection to MongoDB using both the hosted and locally installed instances of your Dreamfactory Services Platform (DSP). First things first: make sure we have a Mongo data… --- ## [PostgreSQL DB credentials are removed whenever I "Save and Clear Cache" for a service](https://community.dreamfactory.com/t/postgresql-db-credentials-are-removed-whenever-i-save-and-clear-cache-for-a-service/5281)
**Author:** [@akaHeimdall](https://community.dreamfactory.com/u/akaHeimdall)\ **Replies:** 0\ **Last updated:** [February 16, 2021, 7:05pm UTC](https://community.dreamfactory.com/t/postgresql-db-credentials-are-removed-whenever-i-save-and-clear-cache-for-a-service/5281 "2021-02-16T19:05:07Z")
I don’t know why but I can verify that this happens every time. I have reproduced this multiple times. I am using a separate login that only has readonly (acct is called “readonly”) access to the tables and views I need… --- ## ["500 Failed to retrieve records" error using PostgreSQL](https://community.dreamfactory.com/t/500-failed-to-retrieve-records-error-using-postgresql/5264)
**Author:** [@akaHeimdall](https://community.dreamfactory.com/u/akaHeimdall)\ **Replies:** 1\ **Last updated:** [February 16, 2021, 6:59pm UTC](https://community.dreamfactory.com/t/500-failed-to-retrieve-records-error-using-postgresql/5264 "2021-02-16T18:59:38Z")
I’ve configured the service, app, and roles for my endpoint. I can successfully run API calls on /schema, /function, /table - basically all the single nodes that don’t have a table name. When I do add a table name (e.g… --- ## [Cannot connect to api from outside of DreamFactory](https://community.dreamfactory.com/t/cannot-connect-to-api-from-outside-of-dreamfactory/5265)
**Author:** [@akaHeimdall](https://community.dreamfactory.com/u/akaHeimdall)\ **Replies:** 0\ **Last updated:** [December 26, 2020, 8:55am UTC](https://community.dreamfactory.com/t/cannot-connect-to-api-from-outside-of-dreamfactory/5265 "2020-12-26T08:55:22Z")
I’ve connected everything successfully inside of DF: My services and roles are working correctly I can successfully execute the “Try Now” buttons in the API DOcs and I can view items on the Data page. I have CORS compl… [Previous page](https://community.dreamfactory.com/latest.md) [Next page](https://community.dreamfactory.com/latest.md?page=2)