I have configured an select SQL node within a workflow to calculate a custom variable which works as this can be seen within the resulting request but the custom variable is not being passed to AFX.
The screenshot below shows both the SQL select node named "Calculate OU" which has a basic statement:
SELECT
CASE
WHEN ${access_request_cri_meu_department} = 'Information Systems' THEN 'Infosys'
WHEN ${access_request_cri_meu_department} = 'Clients Department' THEN 'Clients'
Else ${access_request_cri_meu_department}
END AS AFXCUSTOM_CUSTOM_CALOU
FROM DUAL
The highlighted Activity node has all the fields available to send to AFX but I cannot work out the format the specify the custom variable. If I just add something like "Test" rather than what's currently there "Test" will be passed to AFX but I need to pass the custom field. If the field is left blank I just get "Null payload" as the output in by AFX.
I have configured my AFX connector as below:
Can anyone provide some advise of what I'm doing wrong?
Are you able to pick up variable from right-click menu?
Did you set "Variable Type" of SQL node to "Job"
Variable in the workflow should be ${jobUserData_AFXCUSTOM_CUSTOM_CALOU}