SQL query in javascript on Azure

Question

I have followed a tutorial to write a script on Azure for a custom SQL to retrieve some data: https://www.tapanila.net/windows-azure-mobile-services-custom-api-for-existing-sql-database/

Im working on a mobile service, and use "Easy API" on Azure.

I get an error when I write this script:

exports.get = function(request, response) {
    request.service.mssql.query(
        'select * from varegrupper', {
        success: function(results) {
            response.send(200, results);
        }
    });
};

This is my error:

{"error":"Cannot read property 'mssql' of undefined"}

Any idea what I have missed?

Dale Anderson · Accepted Answer · 2016-06-16 18:21:18Z

3

There is a significant difference between Mobile Services (now deprecated) and Mobile Apps. The API you're trying to work with is the Mobile Services API, where you are using Mobile Apps. You can find a sample project with a custom API that executes SQL statements here. You can also find some reference documentation here.

answered Jun 16, 2016 at 18:21

Dale Anderson

1,70917 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Lars Ørjan Nese Over a year ago

You nailed it. Poor official documentation. Thank you!

Adrian Hall Over a year ago

The documentation you are using (tapanila.net) is not official. The official documentation is on azure.com - go to Documentation -> Web & Mobile -> Mobile Apps

David Makogon · Accepted Answer · 2016-06-16 12:34:04Z

1

Try to directly use mssql object in the code, because the objects in the list of the article which can be directly used for mobile service javascript backend. More details for mssql object, please see https://msdn.microsoft.com/en-us/library/azure/jj554212.aspx.

edited Jun 16, 2016 at 12:34

David Makogon

71k22 gold badges145 silver badges204 bronze badges

answered Jun 16, 2016 at 7:58

Peter Pan

24.2k4 gold badges31 silver badges47 bronze badges

4 Comments

Lars Ørjan Nese Over a year ago

Thanks for your answer. I have tried this. But the Visual Studio online does not know anything about this object it seems. See image: dropbox.com/s/oxjekrhsdz7stjb/mssql.png?dl=0

Lars Ørjan Nese Over a year ago

Found a similar case here: stackoverflow.com/questions/28264430/… but no solutions. Maybe I am missing something in the Azure setup?

Peter Pan Over a year ago

@LarsØrjanNese Does it works with ignoring code check? The code of the similar case seems to be from the offical tutorial azure.microsoft.com/en-us/documentation/articles/…. I doubt the issue was caused by inputting the incorrect user/password for SQL Azure. Please try to connect the SQL Azure alone before create mobile service instance.

Lars Ørjan Nese Over a year ago

I get access to the SQL Azure from "everywhere". And my app (iOS) is working like a charm to access the Azure SDK to run simple queries. But to use this api thing seems tricky.

Collectives™ on Stack Overflow

SQL query in javascript on Azure

2 Answers 2

2 Comments

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related