Integrating quantify database with Power Automate through HTTP/REST API

#1

Hello,

We are looking to connect quantify database with Power Automate to pull the projects table and product catalogue tables data from the API but couldn’t find any example/documentation here.

Could you please provide some examples how to connect to quantify database through HTTP/REST API with authentication type and endpoints to the tables, examples with swagger-file or postman illustration would helps us a lot to replicate the same in Power Automate.

Looking forward your response and appreciate your help. Please let us know if you need further details.

Thanks

#2

Hello Bharath. We do not have an HTTP/REST API. If you would like this sort of API you will need to create a wrapper on top of our .NET API to provide this service. You can look at our sample code to see the sort of operations you will need to perform.

Sample code is here
https://quantifyapi.avontus.com/t/sample-c-project/14/7

And Here
https://quantifyapi.avontus.com/t/sample-code-to-synchronize-invoices-with-accounting-software/41/7

#3

Hello Team,
Thanks for your update.
We are looking to pull data from each jobsite related records (as shown in the screenshot) and all product catalogue tables data.

We are looking for the .Net methods/functions to access those information. We have successfully connected the quantify in our console application. Could you please provide sample code or existing approach for this?

Accssscreenshot
Accssscreenshot.png811×450 287 KB

Thanks
Barath

#4

Hi, Bharath.

Please find some our existing sample code below that can used to fetch the catalog, branches, yards, staging areas and jobsites and stocked parts. Visual Studio intellisense would list all the available properties in the each class.

//GET PRODUCT CATALOG
var products = ProductList.GetProductList(ProductType.Product);
foreach (var product in products)
{
    Console.WriteLine($"PART-NUMBER: {product.PartNumber} DESCRIPTION: {product.Description} LIST-PRICE: {product.DefaultList}");
}

//GET BRANCHES, YARDS, STAGING AREAS
StockingLocationList locations = StockingLocationList.GetBranchOfficesLaydownYardsAndStagingAreas(false, Guid.Empty);
foreach (var location in locations)
{
    //PRINT LOCATION DETAILS
    Console.WriteLine($"LOCATION: {location.Name} NUMBER: {location.Number} ADDRESS: {location.TheAddress.FullAddress}");

    //GET PARTS AT THE  BRANCH, YARD OR STAGING AREA
    var stockedProducts = StockedProductList.GetStockedProductList(location.StockingLocationID, Guid.Empty, ProductType.Product);

    //PRINT PART DETAILS
    foreach (var part in stockedProducts)
    {
        Console.WriteLine($"PART-NUMBER: {part.PartNumber} DESCRIPTION: {part.Description} QTY-FOR-RENT: {part.QuantityForRent}");
    }
}

//GET ACTIVE JOBS
StockingLocationList jobs = StockingLocationList.GetActiveJobsites(false, JobTreeNodeDisplayType.Name, Guid.Empty, false);
foreach (var job in jobs)
{
    Console.WriteLine(job.Name);

    //GET PARTS AT THE  JOB
    var stockedProducts = StockedProductList.GetStockedProductList(job.StockingLocationID, Guid.Empty, ProductType.Product);

    //PRINT PART DETAILS
    foreach (var part in stockedProducts)
    {
        Console.WriteLine($"PART-NUMBER: {part.PartNumber} DESCRIPTION: {part.Description} QTY-ON-RENT: {part.QuantityOnRent}");
    }
}
#5

Hi Team,

How to fetch the category name from this below code its showing only Category ID but in quantify UI category Name is showing

var products = ProductList.GetProductList(ProductType.Product);
foreach (var product in products)
{
Console.WriteLine($“PART-NUMBER: {product.PartNumber} DESCRIPTION: {product.Description} LIST-PRICE: {product.DefaultList}”);
}

Thanks
Bharath

Category
Category.jpg1223×355 59.9 KB

#6

Hi, Bharath.

To get category-name from category-id, you can use GetProductCategory() method in ProductCategory class.

Thank you for posting!

1 Like