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 -
Hey everyone,
Just wanted to chime in on this issue. I totally feel the frustration that comes with these kinds of errors...
@pliu, I've encountered something similar before when integrating Salesforce data into Domo. It sounds like you're on the right track suspecting the API version discrepancy. Salesforce updates its APIs quite often, and if Domo's connector is still relying on an older version, it can indeed lead to compatibility issues.
A quick solution would be to check if Domo has an update or patch that supports the newer API version. Sometimes these platform updates can take a bit to catch up with changes on services like Salesforce.
On a personal note, I once faced a similar situation when trying to integrate a custom object, and the API version mismatch was the root cause. After updating the connector and revising the queries, things worked smoothly.
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 602 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 693 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 386 Distribute
- 111 Domo Everywhere
- 269 Scheduled Reports
- 6 Software Integrations
- 113 Manage
- 110 Governance & Security
- 8 Domo University
- 30 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive