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 them into my SQL DB using a lookup table. However, when trying to use a parameter in the “Object Type” field, i get an error, despite the parameter not being null. See attached.

Thanks

pipeline
salesforce
  • SpiroTaleski's avatar
    SpiroTaleski
    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

8 Replies

  • SpiroTaleski's avatar
    SpiroTaleski
    Valued Contributor
    6 years ago

    Hi @Tommy,

    If you attempting to get the Object Type from pipeline parameters please try this way(screen below) :

    Let me know if you have any questions.

    Regards,
    Spiro

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

    Hi @Spiro_Taleski ,

    It is a value from input schema not a pipeline parameter. It is populated correctly as you can see from the output preview in my screenshot. However when running the validation i get the error “cannot lookup property on null value”. The value is not null.

  • 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

  • clinton_hemmant's avatar
    clinton_hemmant
    New Contributor III
    2 years ago

    Hi

    I have the same problem, except with the Salesforce Update

    Regards

    Clinton

  • SpiroTaleski's avatar
    SpiroTaleski
    Valued Contributor
    2 years ago

    clinton_hemmant 

    If you want to set the Salesforce object dynamically: 

    1) Make sure the value of the field "salesforceObject"(that you are passing to the Salesforce Update Snap) from the upstream snap(perhaps is Mapper Snap) is not null. 

    2) Check if you are actually sending the field "salesforceObject" from the upstream snap to the Salesforce Update. 

    A screenshot from the upstream snap will help here debugging the issue. 

    BR,

    Spiro Taleski