Salesforce - Custom Query - 'Invalid_Field' - Invalid Field

Hi,

 

I am able to create a query using the query builder in salesforce that returns the data I want to see. But the trying to use the same query in the salesforce connector returns 'INVALID_FIELD' (invalid field).

 

Is there something special about custom fields that DOMO cannot access them ??

 

This is the query

 

SELECT
  Account.Name,
  Account.Billing_System_State__c,
  Account.GL_GQ_Eligible__c,
  Amount,
  CloseDate,
  CreatedDate,
  IsClosed,
  IsWon,
  LastModifiedDate,
  LeadSource,
  Name,
  Owner.Name,
  StageName
FROM
  Opportunity

Best Answer

  • vblain
    vblain Member
    Answer ✓

    Problem resolved. Seems it was on SF side last night potentially due to some update. It now works perfectly.

Answers

  • vblain
    vblain Member
    Answer ✓

    Problem resolved. Seems it was on SF side last night potentially due to some update. It now works perfectly.