Salesforce returned a 'INVALID_FIELD' error after the 'Custom Fiscal Year' is enabled in SFDC.


Below is the error I received...
>>>
Domo is ready, but Salesforce returned a 'INVALID_FIELD' error. Please fix the query and try again. Fiscal,FiscalQuarter,FiscalYear ^ ERROR at Row:1:Column:1026 No such column 'Fiscal' on entity 'Opportunity'.If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names. API Call: https://gigamon.my.salesforce.com/services/data/v29.0/query?
>>>
Could this issue be related to the Salesforce API version? Salesforce Spring '16 API is v.36, it looks like Domo’s Salesforce connector still uses v.29
**Please mark the post that solves your problem as "Accepted Solution".
Best Answer
-
It looks like SFDC removed the Fiscal Year related fields from the Opportunity object after we enabled the Custom Fiscal Year feature, the issue went away after we removed the Fiscal Year related fields from our Domo data source.
**Say "Thanks" by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as "Accepted Solution".0
Answers
-
It looks like SFDC removed the Fiscal Year related fields from the Opportunity object after we enabled the Custom Fiscal Year feature, the issue went away after we removed the Fiscal Year related fields from our Domo data source.
**Say "Thanks" by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as "Accepted Solution".0
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 470 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 194 Visualize
- 253 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 174 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive