Data lost/empty fields when adding records/populating fields with HTML data using (Alteryx) API
Hello,
My setup:
1. I get text data from sources, blend and mangle it together in Alteryx
2. Data leaves Alteryx via API tool, arrives in table in Quickbase
I can add records easily from Alteryx.
Where I'm having issues is when I try to send over text data which includes HTML tags.
The field I want to sent HTML information into is a Rich Text field.
The problem is that some of the records will not populate the the HTML information in the Rich Text fields; it populates absolutely nothing. To add insult to injury, if the Rich Text field gets skipped, it will fail to populate any subsequent fields in the record.
I spent a few hours stripping out various tags I can live without in Alteryx...the usual suspects, like ', &, <BR>, a handful of others, and I can't seem to find the right combination to get it where I am able to successfully send over data every single time where all the fields are populated.
Does anyone have experience with this? Are there things I should be doing in Alteryx to make sure that the data is
QuickBase friendly?
Thanks
------------------------------
Nicholas White
------------------------------