Forum Discussion

ChristopherKnie's avatar
ChristopherKnie
Qrew Trainee
7 years ago

How do I encode ampersands located in an XML Do_Query field string so that they get properly decoded on Quickbase's end?

I have an automated system that, when triggered, uses information associated with the trigger to run a query and update another record based on the result of that query. There are a few fields rela...
APIs and custom code
App builders
AustinK's avatar
AustinK
Qrew Commander
7 years ago
Have you tried to use CDATA?

I'm not positive it will work perfectly for this but it sounds like it might.

I guess you could try using & as well, just to check if that worked. Also %26, just because why not test it to be sure.

What works in this exact situation might even be a combination of the above things. I've seen both CDATA and percent encoding be needed before in other things but I don't use XML much with QuickBase.
ChristopherKnie's avatar
ChristopherKnie
Qrew Trainee
7 years ago
CDATA did the trick!
You have to open and close the CDATA tag inside of the query tag. So basically:
<query>     <![CDATA[. . .]]> </query>