Salesforce Schema - updateable, createable attributes

Six Stars

Salesforce Schema - updateable, createable attributes

Salesforce has attributes that describe actions that can be taken on the field.  For instance each field has attributes updateable (the field value can be updated), creatable (the field value can be specified during create), etc.  

 

Salesforce has the concept of "calculated" fields (called formula fields).  These fields are NOT updateable.  It would be great to have these attributes available after Talend generates a schema from salesforce.  Consider the following:

 

There is an Account object with 400 fields, and 40 of them are formula fields which cannot be updated. Assume you want to move this data between salesforce environments (eg. production to sandbox).  

Generate the talend account schema with 400 fields.  

You must manually exclude the 40 fields from the schema / tmap, etc.  

 

There is no programatic way to determine the fields readability from the salesforce attributes in Talend.  So every time the account schema is refreshed you must go in and remove the non-updateable fields manually.  Now imagine doing this for 30 salesforce objects a few times a month...

 

It would be great to have this attribute from salesforce in talend so it can be referenced programatically.  


Accepted Solutions
Moderator

Re: Salesforce Schema - updateable, createable attributes

Hello,

Could you please create a new feature jira issue on talend bug tracker?

https://jira.talendforge.org/secure/Dashboard.jspa

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

All Replies
Moderator

Re: Salesforce Schema - updateable, createable attributes

Hello,

Could you please create a new feature jira issue on talend bug tracker?

https://jira.talendforge.org/secure/Dashboard.jspa

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

Re: Salesforce Schema - updateable, createable attributes

Great, thank you.  I created TDI-40013 (I hope that's the right project).