Standard Salesforce Fields not Available via Input and Output Connectors

Hello,

I'm running into an issue where not all fields on the Order object are accessible via the Salesforce Input and Output connectors. Specifically, I'm getting the following error:

The following fields are not members of the target table: EndDate

I've checked every visibility and security setting I can think of and have found no anomalies. I've also verified that the field shows up correctly in Salesforce reports, via the API in Eclipse, and even in Tableau reports (all using the same user account). Other Alteryx community posts have suggested that there may be an API version issue, but EndDate is supposedly accessible at least back to version 30.

Does anybody have any clues as to why the Salesforce connectors would exclude certain standard fields but include others (it shows custom fields fine as well)?

Thanks,

Rick

Input

Output

Connectors

Salesforce

Accepted answers

rpaugh

Found the problem. I went into the Salesforce Input connector macro itself and found that the initial call is using API version 34.0...

Alteryx-SFDC API Call 1_2017-03-07_13-04-14.png

...whereas subsequent calls are only using version 20.0...

Alteryx-SFDC API Call 2_2017-03-07_13-04-40.png

Alteryx-SFDC API Call 3_2017-03-07_13-05-04.png

Not sure why this is, but the field I'm after is not available all the way back to version 20.0.

rpaugh

I upgraded to Alteryx version 11 this week and all of the previously missing fields are now visible, so problem solved!

All comments

DanM

@rpaugh

Error: Salesforce Output: The following fields are not members of the target table’

Please check that all the tables and output fields exist. As stated above the Salesforce Output tool will not create new tables or fields

Are you able to get to the EndDate field using the custom query?

There are API versions that may be limiting what fields come into Alteryx. Tableau and Eclipse may be using different API versions.

rpaugh

All tables and output fields exist - as they can be consumed by other applications such as Tableau and Eclipse.

No, I am not able to get to the EndDate via custom query:

Alteryx Field Error.png

Granted, Tableau and Eclipse might be using a newer API, but as I mentioned in my original post the EndDate field has been accessible since at least API version 30 whereas the Alteryx SFDC connector is using a newer version than that (I'm going to check with my admin on this just to be sure though). From what I gather this field has been part of the Order object for a long time so I'm not sure what would be affecting it's accessibility - especially since I can access StartDate just fine.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335