rest api extension

REST API QUERY WITH LIKE OPERATOR AND a percent sign (%)

Hi all,

I'm trying to do a query using the like operator with % ( a percent sign (%) that matches any sequence of zero or more characters ), example SELECT * FROM clients WHERE country = 'France' AND city LIKE '% a%'

In queries.properties I've tried:
GetClientsByLike = SELECT * FROM client WHERE country =: country AND city LIKE%: city% but did not work,
also tried ... LIKE :city and pass % sign via parameter, but also did not work.

thanks
Paulo

Update BDM From API Rest Extension

Hello,

Do you know if there is a way to update Business Object from my BDM inside a Rest API extension ?

If yes, where can i find exemples ?

Thanks,

Kilian

Notifications