Hi! I am using DreamFactory as a rest api connector to my MySql database. I have that setup and working properly. I am trying to use this rest api with my appery.io app. I can setup the data connections and get successful tests. What I can’t do is to get the api to return any data. For example…

Working with this user via email - will post solution when we arrive at it. Thanks, Mark

I GOT IT TO RETURN DATA!! Will this session token expire?

:smile: yes, in 24 mins or so, I believe. This is something that cannot be changed on the hosted edition, however, you can manually override this by getting the locally installed version. Glad to see you’re in good shape now! Thanks, Mark

So i would need to install it on my server. Right? Also, I cant seem to get it to filter data. Any examples or hints?

Right - you’ll have to install it on server or use in cloud. As far as filtering data, I assume through the Live API you’re having trouble using the “where” clause syntax. Assume the “where” is already there… in which case, this would be a successful filter: field (operator) ‘xyz’ name LIKE ‘%fa…

Yes, to override session duration you need to install on a server or your local computer. Easiest way to do that is with the Bitnami installers https://bitnami.com/stack/dreamfactory . Filtering with the API uses SQL syntax. The best way to see it in action is by entering a query string in the ‘filt…

[image] Stored procedures on free hosted version REST API Hey Robert, Regarding the second part of your question, you can filter with the API on multiple fields with AND / OR clauses and operators, same as you do with regular SQL filters. You can try it out in the API doc…

I can get it to filter great through the appery service setup. I just can’t figure out how to transfer that to the appery datasource settings. I think I need a javascript for it. I am no programmer, but taking classes. :frowning:

Appery.io rest api help

REST API

Mark September 16, 2014, 3:47pm 8

Have a look here, too!

Topic		Replies	Views
Usage of Dream factory? REST API rest	0	1564	December 4, 2017
Conditional query/API call REST API	7	4175	April 8, 2015
Very simple question REST API	3	2616	July 9, 2015
I'm New To Dreamfactory! REST API	2	1876	November 29, 2014
DB: how could call a DB function? REST API	14	9603	March 24, 2016

Appery.io rest api help

Related topics