Skip to main content
Level 2
Aug 12, 2020 6:00 PM UTC
Solved

Update/modify Filters for a Query with SOAP/XML

What function can I utilize to update/add/modify filters for a query in a workflow? 

 

I asked this similar question (https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/how-do-i-update-the-filter-on-a-query-through-soap/qaq-p/372697) but it doesn't really allow me to change it other than by adding new variables via an external signal. The variables themselves are useful but doesn't address adding or removing filters.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Sukrity_Wadhwa
Sukrity_WadhwaAccepted solution
Level 4
Aug 27, 2020 10:46 AM UTC

Hi @perry_liu ,

Were you able to solve this with the solution provided here? Let us know.

Thanks!

Sukrity Wadhwa

6 replies

Jonathon_wodnicki
Community Advisor
Community Advisor
Aug 13, 2020 5:24 AM UTC

Hi,

 

Use SOAPAction: xtk:persist#Write

<?xml version='1.0'?> <SOAP-ENV:Envelope xmlns:xsd='http://www.w3.org/2001/XMLSchema' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:ns='urn:xtk:persist' xmlns:SOAP-ENV='http://schemas.xmlsoap.org/soap/envelope/'> <SOAP-ENV:Body> <Write xmlns='urn:xtk:persist' SOAP-ENV:encodingStyle='http://schemas.xmlsoap.org/soap/encoding/'> <__sessiontoken xsi:type='xsd:string'></__sessiontoken> <domDoc xsi:type='ns:Element' SOAP-ENV:encodingStyle='http://xml.apache.org/xml-soap/literalxml'> <workflow _operation="update" id="8620" xtkschema="xtk:workflow"> <activities> <query _operation="update" label="1 equal to 1" name="query"> <where _operation="delete" id="3450798105"/> <where _operation="insert" displayFilter="1 equal to 1" filterName="backGroundFilterFrm" id="3455451164"> <condition compositeKey="" dependkey="" enabledIf="" expr="1 = 1" internalId="3455254554"/> </where> <humanCond>Query: 1 equal to 1</humanCond> </query> </activities> </workflow> </domDoc> </Write> </SOAP-ENV:Body> </SOAP-ENV:Envelope>

 

Thanks,

-Jon

Translate
Marcel_Szimonisz
Community Advisor
Community Advisor
Aug 18, 2020 7:16 AM UTC
So you have to define what you want to remove and what you want to add <where _operation ="delete" id ="3450798105" /> nice.. 🙂
Translate
perry_liuAuthor
Level 2
Aug 13, 2020 3:08 PM UTC

.

Translate
Sukrity_Wadhwa
Sukrity_WadhwaAccepted solution
Level 4
Aug 27, 2020 10:46 AM UTC

Hi @perry_liu ,

Were you able to solve this with the solution provided here? Let us know.

Thanks!

Translate
Sukrity Wadhwa
perry_liuAuthor
Level 2
Aug 27, 2020 1:10 PM UTC
It was answered in my other thread. Thank you!
Translate