Passing null values in query string

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.

Have you tried doing it by POST instead?

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.

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

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