Get the data from Cin7

[Anonymous]

I have to connect the Cin7 inventory tool to power BI.

Please let me know any option in power BI to connect the CIn7 tool. 

[Greg_Deckler]

Their website and documentation is fairly unhelpful. What you would be looking for is some type of RESTful web services interface for getting access to your data in either a web page, JSON, XML or other common data format. 

[Anonymous]

I want the connection like Excel or SQL. 

So when I refresh the data new data is updated and my dashboard is also updated. 

I can connect to the power BI services. 

I want to create a visualisation of the inventory data of Cin7.

-------------------------------------------------------------

[Greg_Deckler]

There is no content pack (app) for Cin7. And the Service itself only supports Excel and SQL. Your best option is to download Power BI Desktop and use the web connector, JSON connector, XML connector, OData connector, etc. If Cin7 has a RESTful web service that supports this then you could use Desktop to build your reports, publish the PBIX file to the Power BI Service and then, as long as the source is some sort of RESTful web service then the "cloud gateway" in the Power BI Service should support automatically refreshing data on a scheduled basis. 

[Anonymous]

ok, thanks for the help!

I will check the API document of Cin7

[ajrajes]

@Anonymous Hi, did you have any success with accessing Cin7 Data using API. I am also trying to achieve the same objective as you mentioned in this forum. Any help would be much appreciated. Thanks 

[Posmosis]

For anyone interested I have written a couple of integrations using Microsoft Excel as the Middleware. Works great.

[LGLaing]

@ajrajes 

Are you happy to share via the forum what you have done

Thanks

Lloyd

[Posmosis_]

I am a consultant specialising in ERP systems for retailers/wholesales, but really can be any type of database.

I work with multiple CIN7 clients along with some other prominent higher end systems.

In regard to what I have done with CIN7, I have developed some advanced tools and integrations for my clients based on the CIN7 API.

The tool I have developed is based on ELT (Extract-Load-Transform).

Solutions I can provide;

• Advanced Excel/database users – I provide the API extraction template (In Excel), they then take that and develop it as they require for many different tasks.
• Average Skilled Excel user (Comfortable with basic excel operations like pivot tables, ranges, vlookup) – I can normalise and refine the data in the framework to suit what you do.
• Application – Develop end to end automated solutions (Usually in Excel) which bust complex and time-consuming business processes.
• Integration – ELT data into other systems (IE to website, sales tool, BI Tool)