transaction distribution list question (Power BI Custom Connector) General Ledger

Conor Lynch
Conor Lynch
Fourth Anniversary Facilitator 1
in SKY Developer General Discussions

Hi,

I am being asked by a colleague to come up with all transactions with the prefix of “5-72-1823-xxxx” where the Project ID is also varied, but the initial 3 pieces of the Account Number is of course the same.

Is there a way to add a wildcard to include any Account #s that begin with “5-72-1823”? The only other thing I can think of is to have to pull the list of all of our project IDs, then loop through each and filter into just the account #s I want.

I am not finding anything even in the SKY API documentation on a wildcard or other way of obtaining the information I would like to obtain.

Any help either with a wildcard or more efficient way than querying all of our project IDs would be very appreciated. ?

Tagged:

Categories