Azure Logic App Sql Connector -
i working on logic app pulls cdc data sql server db. using rows operation problem comes in when try use filter query parameter.
code eq '793'
(works)__$operation eq '2'
(not working)@{string('__$operation')} eq '2'
(not working)
i think problem might "$" character.
error message
{ "status": 400, "message": "syntax error @ position 12 in '__$operation eq '2'' " }
can please me!
$
reserved character according odata normative, should percent-encoding before uri formed. unfortunately, tried percent encoding , still syntax error, seems it's not allowed in filter query.
solution
here solution, in logic app cannot use %
in filter query, can't use %24
$
, instead should use _x0024_
.i can result now:
note there 3 _
@ beginning. can use pattern if have other special characters in field/column name. example, if field name display name
has space character in between, in filter query, need convert display_0x0020_name
for more details encoding, please refer encode , decode xml element , attribute names , id values
Comments
Post a Comment