Using wildcards in parameters

Matt McAllister

Hello,

My goal is to get a sum of GL transactions by Fund/Project from specific account types. I'm using the Transaction distribution (List) endpoint. It's pulling all transactions by Project with parameter ui-project-id. Project type isn't a listed parameter, but we've got it as the third segment in our Account Number, so my thought would be a parameter ‘account_number LIKE %DI'

Nothing I've tried as work. Has anyone had any luck using an API parameter with a wildcard? I can manage this with post-processing but it's always nice if you can get the correct dataset from the start.

Thanks!

Matt

Steven Cinquegrana

@Matt McAllister I'm not aware of any API endpoints that accept wild cards (*, %, etc), not even search calls. There is some support for partial text on a few endpoints but it's not common.

If you do a Community search on “wildcard” you'll see some comments around this. Personally, I'd love to see this functionality supported as well, at least for some endpoint types.

Cheers,

Steve Cinquegrana | CEO and Principal Developer | Protégé Solutions

Matt McAllister

@Steven Cinquegrana

Thanks for the reply Steven.