How to filter a rest service response

[sdanigo]

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

[EJLD]

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

[sdanigo]

Hi Eric,
thanks for your response.

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

Thanks

Sylvain

[EJLD]

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

[sdanigo]

Thanks a lot.

[EJLD]

avec plaisir

[EJLD]

avec plaisir