Query Builder Error Message

  • 173Views
  • Last Post 21 December 2022
0
votes
Jennifer Good posted this 20 December 2022

Hi,

I am trying to build a query using Query Builder, but am getting an error message: 

SELECT AcctSeed__Account__r.Name, Advertiser__r.Name, AcctSeed__Cash_Receipt__r.Name ^ ERROR at Row:1:Column5 Didn't understand relationship 'Advertiser__r' in field path. If you are attempting to use a custom relationship, be sure to append the '__r' after the custom relationship name. Please reference your WSDL or the describe call for the appropriate names.

I am selecting the fields from the left, so not sure why I would be getting this message when the SQL should be generated correctly for me using this method.

Thanks,

Jennifer

 

0
votes
Serhii Muzyka posted this 21 December 2022

Hi,

Thank you for contacting Skyvia Support.

 

Such an error occurs in cases when there were some changes made in the source (field removed, etc.) while metadata of the connection being used in Skyvia has not been updated. Most likely, the Name objects does not have 'Advertiser__r' field anymore. Please open your Salesforce connection in Skyvia and click the "Clear now" link near the Metadata Cache parameter. Save the connection and try again.

Some useful information is available here: https://docs.skyvia.com/connections/metadata-cache.html

 

Please inform us about the results.

 

Best regards,

Serhii

Close