Passing null values in query string


#1

I am call postgres function using api.
My requirement is to pass null values to some of the parameters
e.g

http://localhost:00/api/v2/postgres/_proc/fn_funcationname?param1=2017-03-10&param2=null

But above api is searching for ‘null’ pattern in postgres table which is wrong.

Please tell me how to search null records using the above api.


#2

Have you tried doing it by POST instead?


#3

Does anyone figure this out? I am having the same problem.

I have a stored proc in MySQL that inserts data into tables. I am passing null as a parameter value to DF API. It’s inserting string ‘null’ instead of setting the null value to that field.

Any help is appreciated.


#4

i have similar issue. i was trying to exclude the paramters but the process complains they are required.
Could someone pls advice?


#5

Have you all tried calling the procedure using POST instead of GET?

http://wiki.dreamfactory.com/DreamFactory/Features/Database/SQL/Stored_Procedures_And_Functions#Using_POST