Salesforce metadata to sql table (create table)

Anonymous — Sat, 16 Nov 2024 03:24:56 GMT

Hi, is it possible to use Talend to create a table in SQL Server with the exact metadata as one Salesforce object? The purpose is to copy all records from salesforce to sql server, but for that we first need to have the exact fields...even the hidden fields!

Thank you!

Re: Salesforce metadata to sql table (create table)

TRF — Thu, 30 Jan 2020 07:28:55 GMT

Yes it is, you have to code it by yourself using the salesforce metadata API.

The following lines will give you access to the metadata for objectName object and to an array with all fields:

DescribeSObjectResult describeSObjectResult = salesforceConnection.describeSObject(objectName);
Field[] fields = describeSObjectResult.getFields();

Then you can access name, label, datatype and so on for all fields with getName(), getLabel() and getType() methods.

Have a look here https://developer.salesforce.com/docs/atlas.en-us.api_meta.meta/api_meta/meta_intro.htm or googlelize for salesforce metadata api example.

topic Re: Salesforce metadata to sql table (create table) in Talend Studio

Salesforce metadata to sql table (create table)

Re: Salesforce metadata to sql table (create table)