Skip to main content
Question

Error 400 writing to AGOL, Invalid html content.

warren156
Forum|alt.badge.img

Hello,

I'm attempting to write a dataset to AGOL. This dataset comes from another system with ~25,000 records. So far I've been reading this dataset and processing it with my workbench without error for a some time now. Last week it began to fail with the error:

"ArcGIS Online Feature Service Writer: Encountered an unexpected error. The error code from the server was '400' and the message was: ''. Details: 'Field WORKDESC has invalid html content.'"

The datset has a field WORKDESC that contains freeform text entry where staff describe the details of a building permit. I suspect from my troubleshooting that somewhere along the line a strange character has been entered that the AGOL writer is interpretting as html content.

I'm looking for some tips/suggestions as to however to 'clean' this field so that this error doesn't hurl my workbench. However, I don't really want to manually dig through the dataset to find the specific character. Is there some general string replacement that will likely catch a character/symbol that could be causing this error?

 

6 replies

nathanatsafe
Safer
Forum|alt.badge.img+7

Hi @warren156, thanks for the question!

 

If you know the offending characters ('&' and '=' for this user) you could simply use a StringReplacer to replace them. There might be a deeper solution, though, based on the advanced feature layer settings accessed through your ArcGIS Admin page.

 

 

Hope this helps!

 

Nathan
warren156
Forum|alt.badge.img
  • warren156
  • Author
  • April 11, 2018

Hi @NathanAtSafe, thanks for replying. I don't necessarily know what character, if any, is causing the issue. I've used a StringCleaner transformer that I think does what you've suggested and removes the '&' and '=' characters within the field but the error persists. Is there something else I could be missing here?

nathanatsafe
Safer
Forum|alt.badge.img+7
warren156 wrote:

Hi @NathanAtSafe, thanks for replying. I don't necessarily know what character, if any, is causing the issue. I've used a StringCleaner transformer that I think does what you've suggested and removes the '&' and '=' characters within the field but the error persists. Is there something else I could be missing here?

Hi @warren156, sorry to hear that. Are you able to upload this data directly through AGOL or from eg. ArcMap? You could attempt to write it to a File Geodatabase with FME and test uploading from other clients. I wonder if it might be useful to contact ESRI at this point to see if they can provide additional information about this specific error.

 

Alternatively, if you or your ArcGIS Online administrator are able to follow the guidance and steps outlined here and here, you may find a fix by turning off the "Filter web content" in your ArcGIS Server feature service settings.

 

Hope this helps.

 

Nathan
oscard
Influencer
Forum|alt.badge.img+21
  • oscardInfluencer
  • Influencer
  • March 13, 2019

I had the same problem.

 

 

To solve this I have used the transformer TextEncoder using HTML as Encoding Type:

 

 

ileung_cnw
Contributor
Forum|alt.badge.img+2
  • ileung_cnwContributor
  • Contributor
  • April 23, 2021

I had the same error and realized I had <NULL> as text in the field. I used NullAttributeMapper to map them back to the null value and it resolved the issue.

bruceharold
Contributor
Forum|alt.badge.img+17
  • bruceharoldContributor
  • Contributor
  • November 15, 2021

Also please see here: https://community.esri.com/t5/arcgis-data-interoperability-blog/writing-html-and-other-amp-lt-and-amp-gt-tagged/ba-p/1116925

 

Reply


Helpful Members This Week

Community Stats

30,983
Posts
117,431
Replies
38,764
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.