Forum | Appery.io

Hi,
I'm new with Appery.

I've setup rest services with API express taht are connected on a mySql database.

in my app, I've copy and past the URL and all works fine.

My URL looks like that:
https://appery.io/apiexpress-api/rest...

As my where is set to {} all records are returned.

I would like to filter these records on an ID.

I have a variable in my local storage (locID) and I've tryed to map it with the service but that doesn't seem to work.

Can someone put me on the track ?

Thanks

Sylvain

hi Sylvain, if I understand well you question
LS is named 'locID'
field is 'ID'

try what follows in where's js:

var locID = localStorage.getItem("locID");
return '{"ID":"'+locID+'"}';

Eric

Hi Eric,
thanks for your response.

Where do I have to put that JS code ?
in the mapping ?

Thanks

Sylvain

yes, in the mapping
before send
right hand top, under query
in where, just copy/past the above
it shld do the job

Thanks a lot.

avec plaisir

avec plaisir