Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Can't see ForecastingQuota records from the Salesforce Connector

soongjoshua
5 - Atom

I'm having an issue where a SOQL query on ForecastingQuota returns 0 results when using the Salesforce connector. However, running the exact same query using the exact same credentials in the Salesforce Developer Console does yield results.

 

Because the query works when I run it from the Salesforce Developer Console, I don't think it's an issue with my permissions. I have the "View All Forecasts" permission and on my profile and the "Allow Forecasting" permission on my user record. I created some Forecast Quotas directly in Setup in Salesforce, and I can see them when I query directly from the Developer Console.

 

I'm using Designer x64 version 2020.4.5. The connector does recognize the ForecastingQuota table and the fields it contains, it just doesn't return any results, even when the query does not contain a WHERE clause.

1 REPLY 1
soongjoshua
5 - Atom

Update: I tried using the Salesforce connector to insert a ForecastingQuota record, and got the following error: 

 

Error: Salesforce Output (1): Record-level error from Salesforce API: "INVALID_OPERATION:Use the current API version when inserting, updating, or deleting a quota value. Some features aren’t available in earlier API versions:--"

 

The Salesforce output tool I'm using uses API version 42. According to the Salesforce documentation, multiple forecast types were not enabled until API version 30.0, and Territory-based forecasts became available in API version 43 and later. Even though I am not using a Territory-based forecast type and I'm not trying to insert any Territory information, I wonder if the fact that Territories were added in version 43 is what's causing the issue.

 

As far as I can tell, I won't be able to use the Salesforce connectors to to work with ForecastingQuota records until the Salesforce connector is updated to a newer API version.

Labels
Top Solution Authors