Devart Forums

Hi,

I am using the latest version of dotConnect with the Layer2 Software Salesforce to Sharepoint Cloud Connector.

When I call 'select * from account' I get all the fields (standard and custom) that were in Salesforce as of a week or so ago. I added two new custom fields today, but they do not show up in the select statement.

I have checked my enterprise WSDL within salesforce and I see the fields there, but I cannot specify to the enterprise soap as a connection parameter (https://login.salesforce.com/services/Soap/c/28.0) as the dotConnect system will only accept (https://login.salesforce.com/services/Soap/u/28.0) as a login option.

Has anyone else had issues with custom fields not showing up? Any workarounds?

You should call salesforceConnectionObject.Cache.RefreshMetadata() in the code to update the local cache after the database schema is changed via web interface.

An alternative way is to remove the C:\Users\YOUR_OS_USER_NAME\Application Data\*.db files. dotConnect for Salesforce will recreate them on the next salesforceConnectionObject.Open().

For more information about cache management, refer to http://www.devart.com/dotconnect/salesf ... Cache.html.

I have the same issue. I am not using any code but layer2 connector so not sure where to write salesforceConnectionObject.Cache.RefreshMetadata()
I do not see C:\Users\YOUR_OS_USER_NAME\Application Data\*.db
Can you give me exact path?

amitloh wrote:I do not see C:\Users\YOUR_OS_USER_NAME\Application Data\*.db
Can you give me exact path?

Replace YOUR_OS_USER_NAME with your actual name. Also check this path: C:\Users\YOUR_OS_USER_NAME\AppData\Roaming\*.db (this is a default path if different paths are not set explicitly via the Data Cache and Metadata Cache connection string parameters).