Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Update/modify Filters for a Query with SOAP/XML

perry_liu
Level 2
Level 2

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-th...) 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.

1 Accepted Solution
Sukrity_Wadhwa
Correct answer by
Employee
Employee

Hi @perry_liu ,

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

Thanks!

View solution in original post

6 Replies
Jonathon_wodnicki
Community Advisor
Community Advisor

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

Marcel_Szimonisz
Community Advisor
Community Advisor
So you have to define what you want to remove and what you want to add <where _operation ="delete" id ="3450798105" /> nice.. 🙂
Sukrity_Wadhwa
Correct answer by
Employee
Employee

Hi @perry_liu ,

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

Thanks!

View solution in original post