解密php中的salesforce自定义字段

Question

I am creating a signin page in php using heroku, I have created a custom text(encryption) field in Salesforce which i want to decrypt in php in order to compare the user entered data with the decrypted data. How can i achieve this? Kindly help if anyone has solution for the same.

while ($row = pg_fetch_row($result)) {
    if (base64_decode($row[1]) == $_POST['password']) {
        echo "You are a validated user/n";
        echo "HELLO" . $_POST['email'];
        exit;
    }
}

Code:

$query = "SELECT Email , Password__c FROM salesforce.contact ;"; 
$result= pg_query($query); 
$row = pg_fetch_row($result);
echo "Row password " .$row[1]; 
echo "<br>"; 
echo "Post password " .$_POST['password']; 
echo "<br>"; 

Output: ($row[2]==>)Row password *********** Post password 123456789 enter image description here

Answer 1

The problem here is that you don't know how the data in Salesforce is encrypted. By default, the data returned from a query on those field is just ******, and there's no way for an external application to decrypt this.

If you want to see the values in those fields, you need the querying user to have the View Encrypted Data permission, which can be given on the user profile or through a permission set.

Once your user has this permission, they will be able to see the plain-text values of the encrypted text field in:

• the ui
• the bulk api
• the rest api
• the soap api
• debug logs (although not when serializing the containing sObject)