How do I add an additional data field to an existing dataset?
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
-
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
______________________________________________________________________________________________0
Answers
-
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
______________________________________________________________________________________________0 -
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.
0 -
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...
0 -
Awesome, that did it. Thank you!!
0
Categories
- 10.7K All Categories
- 1 APAC User Group
- 12 Welcome
- 36 Domo News
- 9.6K Using Domo
- 1.9K Dataflows
- 2.4K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 339 Workbench
- 252 Domo Best Practices
- 11 Domo Certification
- 461 Domo Developer
- 47 Domo Everywhere
- 101 Apps
- 705 New to Domo
- 84 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 23 お知らせ
- 63 Kowaza
- 297 仲間に相談
- 649 ひらめき共有