Forum Discussion

ShaunLeMouton's avatar
ShaunLeMouton
Icon for Helper I rankHelper I
1 year ago
Solved

Fabric Sales Force Connector

Hi,

 

I use the Object SalesForce connector to obtain my datas from Sales Force in my datalake

Have some attributs as picklists in my SalesForce Object

My mapping in Fabrioc is like SalesForce Attribute -> Picklist || Attribut -> String

I need to retrieve all picklist attribut

how can i do it ?

Thx

Need Help
  • v-prasare's avatar
    v-prasare
    1 year ago

    Hi ShaunLeMouton,

     

    Currently, the Salesforce Object connector only retrieves the selected picklist values (as strings), not the full set of allowed values. To get all picklist options, you'll need to use the Salesforce Metadata or Tooling API to retrieve the full list of picklist values for each field. Once retrieved, you can store this metadata in your Lakehouse as a reference table for reporting or validation purposes.

     

    Can you try below steps and let me know if this helps?

    1. Connect to Salesforce Metadata or Tooling API: Use tools like Postman, Workbench, or custom scripts (Python, Java, etc.) to call Salesforce’s Metadata or Tooling API.
    2. Retrieve Picklist Metadata with Describe Call: Use the endpoint GET /services/data/vXX.0/sobjects/ObjectName/describe to fetch all fields. Identify fields of type "picklist" and extract their "picklistValues".
    3. Store Picklist Values in a Reference Table: Save the extracted picklist options to a dedicated table in your Data Lake or Lakehouse. This can be used for dropdowns, validations, or enriching data in reports.

     

     

     

    Thanks,

    Prashanth Are

    MS Fabric community support

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

     

     

     

     

     

     

     

4 Replies

  • v-prasare's avatar
    v-prasare
    Icon for Community Support rankCommunity Support
    1 year ago

    Hi ShaunLeMouton,

     

    Currently, the Salesforce Object connector only retrieves the selected picklist values (as strings), not the full set of allowed values. To get all picklist options, you'll need to use the Salesforce Metadata or Tooling API to retrieve the full list of picklist values for each field. Once retrieved, you can store this metadata in your Lakehouse as a reference table for reporting or validation purposes.

     

    Can you try below steps and let me know if this helps?

    1. Connect to Salesforce Metadata or Tooling API: Use tools like Postman, Workbench, or custom scripts (Python, Java, etc.) to call Salesforce’s Metadata or Tooling API.
    2. Retrieve Picklist Metadata with Describe Call: Use the endpoint GET /services/data/vXX.0/sobjects/ObjectName/describe to fetch all fields. Identify fields of type "picklist" and extract their "picklistValues".
    3. Store Picklist Values in a Reference Table: Save the extracted picklist options to a dedicated table in your Data Lake or Lakehouse. This can be used for dropdowns, validations, or enriching data in reports.

     

     

     

    Thanks,

    Prashanth Are

    MS Fabric community support

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

     

     

     

     

     

     

     

  • v-prasare's avatar
    v-prasare
    Icon for Community Support rankCommunity Support
    1 year ago

    ShaunLeMouton, As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

     

     

     

    Thanks,

    Prashanth Are

    MS Fabric community support

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

  • v-prasare's avatar
    v-prasare
    Icon for Community Support rankCommunity Support
    1 year ago

    @ShaunLeMouton, As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

     

     

     

    Thanks,

    Prashanth Are

    MS Fabric community support

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

  • v-prasare's avatar
    v-prasare
    Icon for Community Support rankCommunity Support
    1 year ago

    @ShaunLeMouton, As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

     

     

     

    Thanks,

    Prashanth Are

    MS Fabric community support

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query