Platform

 View Only

 Query Parameters for REST API

Jump to  Best Answer
  • Datalink
Dawn Kassube's profile image
Dawn Kassube posted Thu September 05, 2024 03:25 PM

Hello,

With the deprecation of the old Microsoft Azure API's to Cost Export Jobs, how do you enter the Query Parameters in Datalink.  I only need ChargeType IN ("Purchase","Refund") and Publisher Type="Azure" but don't know how to do the IN command in the REST API.

Thank you for any insight on how to accomplish this as I do not want to bring in 5Million rows of data when I only need 200 rows.

Thank you,


#Datalink
Varad Rajeev Muthal's profile image
Varad Rajeev Muthal posted Thu September 19, 2024 07:51 AM  Best Answer

Hello @Dawn Kassube, Here is the possible solution from one of our Data Application Engineer:
"The query params only support equal to (=) operator , Customer can try adding the IN operator as part of the URL in Rest Connector"

I hope this will help you!


#Datalink
Varad Rajeev Muthal's profile image
Varad Rajeev Muthal posted Thu September 12, 2024 01:55 PM

Hello @Dawn Kassube, I have noted it down & get back to you soon.

Thanks!


#Datalink
Dawn Kassube's profile image
Dawn Kassube posted Thu September 19, 2024 03:45 PM

Hello Varad,

Can you please give me an example?  This is my Rest URL:  https://xXXXXXXX.blob.core.windows.net/costmanagement-exports/apptio_export1/ActualCost/renamed/ActualCost-{CYYY}{MM}.csv

Since I am going against a blob file can I add the $ChargeType=Purchase?  If so where?

Thank you 


#Datalink