Hello @brnyh ,
Thanks for the ask and using the forum .
Since you mentioned that " I retrieve the filter-value from a Lookup activity from a sqldb-dataset" , i think we can fix it on the SQL side.
I tried to repro
create table test1000
INSERT INTO test1000 values('"210004,2000,4000"')
I am getting the output you called out what you called out .
Now in the Lookup move to query ( i am assuming that you were using the tablke before ) with something like .
select substring(columanname,2,(len(columanname)-2)) as'columanname'
Output now is :
Let me know if this helps .
Please do consider to click on "Accept Answer" and "Upvote" on the post that helps you, as it can be beneficial to other community members.
We have not heard back from you on this and was just following up .
Incase if you have resolution , request you to share the same here , so that other community members can benefit from that .
Thank you for trying to resolve this. However, the third party API im trying to connect to is not approved for JSON, only XML. Thus, this solution unfortunately doesn't fit my needs. I have went ahead with another service for this part of the pipeline, as i have to move forward and cannot spend more time trying to resolve this is azure data factory as of now.