ETL DataFlow writer unable to add the SalesForce Account Object

More
9 years 11 months ago #8575 by dmart024
Advanced ETL Processor version 5.7.6.0

Hello, I'd like to report a new issue with updating SalesForce records. I'm trying to update some Account records but the writer immediately reports an error after I specify the Account object as the target. The error is "HTTP/1.1 400 Bad Request"


Our Account object has hundreds of extra custom fields. That may be the reason why we get the error. I don't have an non-customized SalesForce instance to test against.


Please see the attached screenshots. Please let me know if you need additional information.

Thanks
Don Martin





Attachments:

Please Log in or Create an account to join the conversation.

More
9 years 11 months ago #8580 by admin
Works fine here

The question is how we can customize our test instance so it will be copy of yours?


Mike

Mike
ETL Architect
Attachments:

Please Log in or Create an account to join the conversation.

More
9 years 11 months ago #8594 by dmart024
I can give you a list of our custom fields and you can create them. As I mentioned before, we have several hundred custom fields. Just don't ask me why we do because I wonder that myself all the time.

Don

Please Log in or Create an account to join the conversation.

More
9 years 11 months ago #8597 by admin
We had simular isuues what we did we started removing mapping one field at the time until we found offending field.

Peter

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
9 years 10 months ago #8624 by dmart024
Peter,

Was there a special character or field name length limit? What was it that caused the problem for you?

Thanks
Don

Please Log in or Create an account to join the conversation.

More
9 years 10 months ago #8633 by admin
Was there a special character or field name length limit? What was it that caused the problem for you?

We were loading the data into fields generated by salesforce (like last modification date)

Mike

Mike
ETL Architect

Please Log in or Create an account to join the conversation.