Data360 Analyze

 View Only
  • 1.  Passing value from one node to another in Salesforce URL request

    Posted 03-15-2021 11:02

    We are trying to pass a list of ID's (from output node) into an "Input" Node for Salesforce query. We are getting an error stating: 

    Tried:

    SELECT
    ACCOUNTID
    ,FIRSTNAME, PHONE
    FROM CONTACT
    where ACCOUNTID = 'ID'

    Error:  Execution ErrorError occurred during executing request: where ACCOUNTID = 'ID' ^ ERROR at Row:12:Column:7 invalid ID field: ID Record number: 1.

    Tried:

    SELECT
    ACCOUNTID
    ,FIRSTNAME, PHONE
    FROM CONTACT
    where ACCOUNTID = '{ID}'

    Error occurred during executing request: where ACCOUNTID = '{ID}' ^ ERROR at Row:12:Column:7 invalid ID field: {ID} Record number: 1.

    Tried:

    SELECT
    ACCOUNTID
    ,FIRSTNAME, PHONE
    FROM CONTACT
    where ACCOUNTID IN{ID}

    Execution ErrorError occurred during executing request: where ACCOUNTID IN{ID} ^ ERROR at Row:12:Column:18 Bind variables only allowed in Apex code Record number: 1.

    This is a Salesforce query. Direct queries to database we have no issues. Is there a specific syntax for Salesforce queries when passing an input field?



  • 2.  RE: Passing value from one node to another in Salesforce URL request

    Employee
    Posted 03-16-2021 08:51

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Looks like this was a duplicate of https://support.infogix.com/hc/en-us/community/posts/1500000513182-Passing-value-from-one-node-to-another-in-Salesforce-URL-request?page=1#community_comment_1500000448122 The question has been answered in the linked thread.