How do I add an additional data field to an existing dataset?

user12192
user12192
in Connectors

I am trying to add an additional data field into an existing dataset and I took the API name from SalesForce and entered it into the dataset query. When it went to run this morning, it gave me an error and said it was incorrect when in SFDC, that is what the API name is. 

What am I doing wrong?

Best Answer

  • ST_-Superman-_
    ST_-Superman-_ 🟤
    Answer ✓

    You need to move the field name up in your query.

     

    It should end with

    ... Altify_Pause_Date__c, Lead_Source_Detail__c FROM Opportunity

    ______________________________________________________________________________________________
    “There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
    ______________________________________________________________________________________________

Answers

  • ST_-Superman-_
    ST_-Superman-_ 🟤

    You need to make sure that the entire path to the API is correct.  Would you mind sharing your query and maybe a portion of the schema map for the salesforce object you are pulling in, highlighting the api in question?

     

    Thanks,


    ______________________________________________________________________________________________
    “There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
    ______________________________________________________________________________________________
  • user12192
    user12192

    Hi There! 

    Thank you for getting back to me. 

     

    I am not sure if I understand completely but I am attaching visuals for you to see. It looks like I can only attach one file per message so here is the SFDC view showing the field I am trying to add. 

  • user12192
    user12192

    Here is the domo view that I am trying to enter in the API exactly how it is in SFDC. 

     

    What else do I need to do? I just want to add 'Lead Source Detail' to the dataset...

  • user12192
    user12192

    Awesome, that did it. Thank you!! 

Categories