We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.

Passing value from one node to another in Salesforce URL request

Comments

2 comments

  • Avatar
    Ryan Klaproth

    If you look at the WHERE expression, it's looking for where ACCOUNTID = 'ID' -- that means it's only valid if the value of ACCOUNTID is literally 'ID' -- I'm not sure if that's normal for Salesforce, but ACCOUNTID sounds like it should be a number, not the literal 'ID'. Maybe that's the problem?

    I found documentation on the SOQL WHERE clause here -- might be useful as well: https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_sosl_where.htm?search_text=where

    0
    Comment actions Permalink
  • Avatar
    Ryan Klaproth

    Another thing I noticed is that it looks like you're trying to reference what I imagine is an input column named "ID" that has the values, and you're trying to replace it with the 'ID" field. That won't work in the Salesforce Node. The "From Field" option for the query means the entire query needs to be input from a field, not just one field on its own.

    You'll need to make the entire query in a Transform Node (if you're outputting from one right now, you can just use that one) and reference the field with the entire query there.

    0
    Comment actions Permalink

Please sign in to leave a comment.