This message was deleted.

Hey Pavel, follow the contributing guide and it’ll show you how you can query the DB for available values, these come from the cloud vendors…

Hi Ali! I want to add Infracost's pricing API data to my open source Cloud Management system: https://github.com/Trolley-MGMT/trolleymgmt I'd be glad to share with you more details if you'd like.

@wooden-smartphone-11475 very cool! Your best bet is to query the Cloud Pricing API’s Postgres DB directly, see here for instructions and example queries: https://github.com/infracost/infracost/blob/master/contributing/add_new_resource_guide.md#price-search

Can't find productName anywhere 😞 looked for it in the code as well and cannot find.. When I run the query like this:

query {
  products(
    filter: {
      vendorName: "azure",
      service: "Virtual Machines",
      productFamily: "Compute",
      region: "centralus",
      attributeFilters: [
        { key: "skuName", value: "DS2 v2" }
      ]
    },
  ) {
    prices(
      filter: {
        purchaseOption: "Consumption",
        unit: "1 Hour"
      },
    ) { USD }
  }
}

I get 3 different values as opposed to this:

query {
  products(
    filter: {
      vendorName: "azure",
      service: "Virtual Machines",
      productFamily: "Compute",
      region: "centralus",
      attributeFilters: [
        { key: "skuName", value: "DS2 v2" }
        { key: "productName", value:"Virtual Machines DSv2 Series Windows"}
      ]
    },
  ) {
    prices(
      filter: {
        purchaseOption: "Consumption",
        unit: "1 Hour"
      },
    ) { USD }
  }
}

with the

productName

key. I'd like to find in the code/db the source of these values for Azure. I just cannot find them. I will continue looking for it, thanks

productName (alongside the skuName) is in

attributes

, try something like this

SELECT DISTINCT "service", "productFamily", "attributes"->>'productName' AS productName, "attributes"->>'skuName' AS skuName FROM products WHERE "vendorName" = 'azure'

checking

in this doc, look for the section that talks about this query:

Much better! Instead of hundreds of records, we reduced the search to four possibilities. But it is still unclear what exactly represents the service. The guess would be the last two rows, but it is uncertain. We need more information, and including the attributes column in the output may help.

.....

SELECT DISTINCT "service", "productFamily", "attributes" FROM products WHERE "vendorName" = 'aws' AND "service" = 'AWSTransfer' AND region = 'us-east-1';

Ok, I run this query now:

SELECT DISTINCT "service", "productFamily", "attributes"->>'productName' AS productName, "attributes"->>'skuName' AS skuName, "prices"
FROM products 
WHERE "vendorName" = 'azure' AND "attributes"->>'skuName' = 'DS2 v2';

And I am getting a lot of different prices responses (165) Is there a way to shorten them to 4 in accordance to the productNames I see in the DB?

Maybe review the attributes column in the DB to see if there are any other properties that has the high-level name you want? e.g.

SELECT DISTINCT "attributes"
FROM products 
WHERE "vendorName" = 'azure' AND "attributes"->>'skuName' = 'DS2 v2';