Dataverse Input Tool - Custom OData Filter

[NazK]

Hi,

Need a bit of advice here! I just started using Dataverse Input tool. I can authenticate to a CRM API endpoint and use the "Manually" option in define filters section to get data from some tables there. 

I cannot figure out how to use the same type of filter expression that I am using on other APIs (still OData) in the "Custom OData Query" option of define filters within the tool, I keep receiving the "invalid custom OData query" error message.

I have also tried searching community posts for a solution or example but ran out of time and could not find a solution.

Can you please share a sample custom OData query that works for you or advise on what changes I need to make to the below?

One of the sample filter expressions I tried was (I tried using the entire expression and also excluding the "$filter =" bit):

$filter = year(ReservationDate) ge 2023

Many thanks

[apathetichell]

Hey - sounds like you have a solid handle of odata api calls and syntax - why not just use the download tool and skip the dataverse input tool?

[NazK]

Hey thanks for the reply,

I have to stick with the dataverse for now as that is the only way the only available authentication method that is setup for us is using Service Principal method for now.

If I am not mistaken using the download tool we can implement OAuth 2 if we know authentication endpoint and what it will return to parse, or Basic Authentication that the tool allows on its own.

Not sure if I have seen a flow for it using Service principal authentication method but if you do know of a sample please do share!

Thanks

[apathetichell]

sorry- I haven't used dataverse - just odata with some other apis. tbh - however alteryx is authing in as service principal you should be able to do via download tool or python or powershell.