- Posts: 86
- Thank you received: 0
ETL DataFlow writer unable to add the SalesForce Account Object
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
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
Please Log in or Create an account to join the conversation.
9 years 11 months ago #8580
by admin
Mike
ETL Architect
Replied by admin on topic ETL DataFlow writer unable to add the SalesForce Account Object
Works fine here
The question is how we can customize our test instance so it will be copy of yours?
Mike
The question is how we can customize our test instance so it will be copy of yours?
Mike
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
9 years 11 months ago #8594
by dmart024
Replied by dmart024 on topic ETL DataFlow writer unable to add the SalesForce Account Object
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
Don
Please Log in or Create an account to join the conversation.
9 years 11 months ago #8597
by admin
Mike
ETL Architect
Replied by admin on topic ETL DataFlow writer unable to add the SalesForce Account Object
We had simular isuues what we did we started removing mapping one field at the time until we found offending field.
Peter
Peter
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
9 years 10 months ago #8624
by dmart024
Replied by dmart024 on topic ETL DataFlow writer unable to add the SalesForce Account Object
Peter,
Was there a special character or field name length limit? What was it that caused the problem for you?
Thanks
Don
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.
9 years 10 months ago #8633
by admin
Mike
ETL Architect
Replied by admin on topic ETL DataFlow writer unable to add the SalesForce Account Object
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
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.