Genesys Cloud - Developer Community!

 View Only

Sign Up

  • 1.  Salesforce data action complex multiple object response

    Posted 06-02-2025 23:41

    Here are the details of integration

    Request URL template 

    /services/data/v62.0/query/?q=$esc.url("SELECT Name, PCA_Primary__r.Username, PCA_Secondary__r.Username from account where Phone = '$salesforce.escReserved(${input.PHONE_NUMBER})' limit 1 ")

    Output contract 

    {
      "title": "Account",
      "type": "object",
      "properties": {
        "accountName": {
          "type": "string"
        },
        "primaryUsername": {
          "type": "string"
        },
        "secondaryUsername": {
          "type": "string"
        }
      }
    }
    Response
    {
      "translationMap": {
        "primaryUsername": "$.records[0].PCA_Primary__r.Username",
        "secondaryUsername": "$.records[0].PCA_Secondary__r.Username",
        "accountName": "$.records[0].Name"
      },
      "translationMapDefaults": {
        "primaryUsername": "Not Assigned",
        "secondaryUsername": "Not Assigned",
        "accountName": "Unknown"
      },
      "successTemplate": "${rawResult}"
    }
    Test results show blank fields

    #API/Integrations

    ------------------------------
    Sukhjinder Brar
    Principal Consultant
    ------------------------------


  • 2.  RE: Salesforce data action complex multiple object response

    Posted 06-03-2025 10:09

    Hello Sukhjinder,

    I have moved your question to the Genesys Cloud - Developer Community. Hopefully one of the experts there will be able to assist you with this.



    ------------------------------
    Jason Kleitz
    Online Community Manager/Moderator
    ------------------------------