Forum Discussion

NicholasWhite's avatar
Qrew Member
3 years ago

Data lost/empty fields when adding records/populating fields with HTML data using (Alteryx) API


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?


Nicholas White
No RepliesBe the first to reply