Power Automate connector to pull Account Number from FENXT

Jacob Dong

I created a Power Automate flow to pull a query result, which includes account number, from FENXT. The query itself is running good. However in the query result pulled by the Power Automate flow, the account number were all converted to 32 digit characters.

Is this something with the confidentiality? Did someone have the same experience?

Alex Wong

@Jacob d***
Which SKY API endpoint are you using or are you using Query API?

Jacob Dong

@Alex Wong
Hi Alex, I was not using SKY API endpoints. I was using the Power Automate flow connector to pull a query result from FENXT Payable.

Ashley Moose

@Jacob d***
Try setting the Formatting Mode to Export or UI. When the Formatting mode is set to None, encrypted fields will export as encrypted in the Query output.

Jacob Dong

@Ashley Moose

Thanks Ashley so much. It worked after switching the setup.

Appreciate your help!!!?