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

user12192
user12192 Member
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 Domo Employee
    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

Answers

  • ST_Superman
    ST_Superman Domo Employee

    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,

  • user12192
    user12192 Member

    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 Member

    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...

  • ST_Superman
    ST_Superman Domo Employee
    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
  • user12192
    user12192 Member

    Awesome, that did it. Thank you!! 

Categories