Forum Discussion

Tommy's avatar
Tommy
New Contributor III
6 years ago
Solved

Salesforce SOQL - Pass Object Type as Parameter

Hello, Is it possible to pass the “Object Type” into a Salesforce SOQL Snap (or Salesforce lookup or Salesforce Read) I want to dynamically pull data from multiple salesforce objects and pull the...
pipeline
salesforce
SpiroTaleski's avatar
SpiroTaleski
Valued Contributor
6 years ago

Hi @Tommy,

Can you please provide screenshot containing configuration of the upstream snap that you are using?

Thanks,
Spiro

Tommy's avatar
Tommy
New Contributor III
6 years ago

Hi @Spiro_Taleski. Sure. The upstream snap is a mapper…

I have also tried hard coding this is a mapper to rule out any schema issues:

I still get the error below on both methods:

  • SpiroTaleski's avatar
    SpiroTaleski
    Valued Contributor
    6 years ago

    Hi @Tommy

    I have tried the same approach using the Salesforce Read Snap and get the same error message. It looks like a SnapLogic bug that does not allow to get the value from the input schema for that field.

    If you are using the Salesforce Read Snap you can specify the Object type from the pipeline parameters(ex : _SFObject).

    If you are using the Saleforce SOQL Snap then you can specify the object type dynamically from the input schema in the SOQL query section of the Snap:

    Regards,
    Spiro

    • Tommy's avatar
      Tommy
      New Contributor III
      6 years ago

      Thanks @Spiro_Taleski.

      I was already passing the object in the SOQL dynamically. I hadn’t even considered leaving the “Object Type” field blank. That worked. Thanks