I'm looking for some guidance regarding a Generic REST AFX Connector configuration.

We have created a Generic REST AFX Connector. The REST call executes successfully, and on the application server we can see that the API returns the expected JSON response:

{

 "Success": true,

 "ReasonCode": 0,

 "ReasonText": "Success",

 "Data": {

  "UserName": "abc_de",

  "Password": "xxxxxxx"

 }

}

We need the value of 'ReasonText' in fulfillment workflow variable '${jobUserData_acm.provisioningCommandStatusMessage}' we are calling this variable from sql select node after the create account provisioning node

Below is the query we are using:

SELECT ${jobUserData_acm.provisioningCommandStatusCode} as prov_status,

${jobUserData_acm.provisioningCommandStatusMessage} as prov_statusmsg

FROM DUAL

Refer to the attached screenshots

Kindly help to resolve this issue