Power Automate connector to pull Account Number from FENXT

Jacob Dong

Jacob Dong

Third Anniversary

Kudos 1

Name Dropper

Facilitator 1

May 23 in SKY Developer General Discussions

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?

0

Comments

Alex Wong Community All-Star

May 26

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

0
Jacob Dong

May 26

@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.

0
Ashley Moose Blackbaud Employee

May 27

@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.

0
Jacob Dong

May 27

@Ashley Moose
Thanks Ashley so much. It worked after switching the setup.
Appreciate your help!!!?

0

Categories