cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Meneghino
Level 10

Help: custom API for SQL Server

Hi all.

 

Given that it is not clear if and when we will ever have the direct capability of retrieving data from SQL Server views into PowerApps, there must be a way of working around by using a combination of Auzre functions and custom APIs.

 

Has anyone managed?  If so, how?  I am only looking to read the data and not write.

 

Many thanks.

5 REPLIES 5
tofsweden
Level: Powered On

Re: Help: custom API for SQL Server

@Meneghino

 

It is possible, one guy did it for me. He did most on the SQL side, by collecting desired info into from a table to some kind of middle phase (a new 'ghost' table?!) on SQL side, then opened a 'Data Connector Gun' gateway between powerapps and SQL. No need of Azure.

Meneghino
Level 10

Re: Help: custom API for SQL Server

Hi @tofsweden

Thanks for the reply.  But how does the data in the 'ghost table' get updated?

Is it updated regularly (i.e. every few hours/days) or do you have to trigger the update?  If you have to trigger the update, how is done?
Many thanks,
Giacomo

tofsweden
Level: Powered On

Re: Help: custom API for SQL Server

@Meneghino

 

SQL have some kind of functionality called View where Gun Connecter see's it and pulls the data.

 

We've been working with SQL - PowerApps and there are many restrictions. Like as you cannot specify latest objects to collect as SQL datatype format 'Date' is not supported by PowerApps own date format. And you can only collect max 2048 objects, which seems to be hardcoded by PowerApps. Very frustating.

Meneghino
Level 10

Re: Help: custom API for SQL Server

Hi @tofsweden

Thank you.  Agreed, it is very frustrating.

KevinPederson
Level: Power Up

Re: Help: custom API for SQL Server

To get a start with Node (API), it is compulsory to install node.js which is an open source runtime environment. It never blocks the task which is meant for providing asynchronous programming. Microsoft Professional Support

Helpful resources

Announcements
thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (5,383)