@qanuj You can use the REST API or directly modify the contents of the database. Unfortunately, there is no in built support for relationships. It's been on the cards for quite a while, but is unlikely to be implemented - it's a complex area. I would suggest that you enforce your relationships in your client app and update individual records. Alternatively, as @SteveALee mentions, you can serialize complex objects into a single string column.
@ephemorality The authentication implementation is not part of Mobile Apps, it's now built in to Azure Web Apps. I don't have enough detailed knowledge of the area to know what's going wrong. I know you're not a fan of posting on stackoverflow, but this is your best option - the team actually has competitions to see who can answer the most questions, so you're pretty much guaranteed a quick response :)
@Anshdesire This is almost certainly because bcrypt is a native module. Are you deploying your node_modules folder when you deploy? If that's the case, you need to ensure that the major version of node you are using (0.10.x, 0.12.x, 4.x, etc) matches the one used on your site, and must also be 32 bit. Alternatively, if you don't deploy the node_modules folder, it should be installed for you when you push.
@atorefrank This channel is for support of Azure Mobile Apps. We don't have anything to do with Azure Containers. I suggest posting on stackoverflow with the appropriate tags.
@lthib It's possible to use a custom identity provider in Mobile Apps. You essentially need to mint your own tokens using the jsonwebtoken library using the signing key that the web app generates. There is an example in the samples folder of the github repo. The sample just covers a simple username / password scenario but should give you good guidance for using your provider.
@rizkyario I see you opened an issue for this. We'll certainly look at implementing this, but resources are a bit stretched at the moment and it may take some time. In the mean time, you could manually insert the authorization properties into the swagger JSON. If you created a similar endpoint in express to the swagger middleware, you could insert the auth properties.
Hope I didn't miss anyone! Thanks for your patience.
@scottpazelt This gitter channel is about Azure Mobile Apps, not sure we'll be able to help. I suggest you post a question on stackoverflow. When you say "authenticate to azure", which service do you mean? Are you trying to authenticate against ARM? You should be able to authenticate against most Azure services using any AAD account that has been granted permissions to the service.
You can set permissions to most Azure services through portal.azure.com by navigating to the service and selecting "Access Control (IAM)"
Hi @danderson00 thanks for the response. I'm referring to authenticating to Azure with Terraform. All the documentation suggests a service principal which isn't a great option. I'd like to know if anyone is authenticating Terraform with some type of AD federated account. Thanks a lot.
Hello all. Got a bit of a question about working with DateTime data types. I know in an ideal world I'd just convert to DateTimeOffset, but I'm working with some legacy data that I can't really touch. I was hoping I could modify the
MobileServiceClient.SerializerSettings.DateTimeZoneHandling to prevent the serializer from assuming it needed to send my DateTime from local to UTC, but that setting doesn't seem to be honored by the client.
What are my options for preventing JSON.NET from making this serialization change?
@danderson00 i created it by my self right now i am looking to use AD auth in node js for getting data from applicationinsights as given in doc https://dev.applicationinsights.io/documentation/Authorization/Rate-limits "Limits when using Azure Active Directory authentication" and https://dev.applicationinsights.io/documentation/Overview/URL-formats "Azure API format".
tables are created with a default constraint:
ALTER TABLE [dbo].[MyTable] ADD CONSTRAINT [DF_MyTable_id] DEFAULT (CONVERT([nvarchar](255),newid(),(0))) FOR [id]. anything i should be aware of before replacing the impl to some string that is not a converted newid()?
Hi guys. I am new to using node.js as a back-end. The samples have been a great help in giving me a feel for how to use it. However I was wondering how I would implement a "Virtual Table". Essentially the "personal-table" sample, but abstracted into a virtual table. So there would be two tables: TodoItem, and PersonalTodoItem. The first, if queried, would return all records. The second, when queried by the client, must query the first table, returning only those with the matching userId. Therefore the second is just a "virtual table". Any help would be GREATLY APPRECIATED! I have been hacking around trying to get this to work but no joy yet...
where should i start to look for potential causes?
I have a SPA application made in react/redux
I’m trying to figure out the best deploy strategy on Azure…It’s frontend only, it consumes API ftom a 3rd party sources
I see there are many options, it would be fine to use CDN + Blob storage
but I need to handle 404 redirect and other rules
is that possible? It is better to use other ways?
@guglielmino you can create an App service
thanks
req.azureMobile.tables('Person').where({
id: person
}).execute().then((results) => {
console.log(results);
}).catch((err) => { console.log(err) });
Hi all,
How do we set cors to the config?
I tried to add codes below in config.js but still received "Origin http://www.xxx.yyy is not allowed by Access-Control-Allow-Origin"
How do we set cors to the config?
I tried to add codes below in config.js but still received "Origin http://www.xxx.yyy is not allowed by Access-Control-Allow-Origin"
var config = {
homePage: true,
swagger: true,
cors: {
hostnames: ["localhost, www.xxx.yyy"]
}
};
I'm doing local development of features and running node.js server using mobile apps fine through Visual Studio code. Until now I have tested stuff with Postman to issue REST calls. Now I want to test with my android app towards my local running instance of the node webserver. But it does not work. I have a token that I have generated to use locally (offline development), which works fine using Postman. Normally a live Azure node backend server will have Auth service infront of the webserver, adding a header called X-MS-CLIENT-PRINCIPAL-ID with the decoded userid sid:xxxxxx from the provided token before it reaches my app. I then use var userID = req.header('x-ms-client-principal-id') to get the ID of the current user. But this does not work when server is running in a local development environment. How can this even be tested offline for development without having to manually insert the sid:xxxxx to the request headers from my android app?
Is there a way to use custom sql statements along with DECLARE @Variable = xxxx properly? I keep getting complains about missing parameter when i attempt to execute the following example
var query = {
sql: 'DECLARE @hello = '1233455'; /* some statements in between */ ; SELECT * FROM t1 WHERE id = @id;',
parameters: [
{ name: 'id', value: request.query.id }
]
};it says hello was missing from query.parameters.
I have a user database and I'm implementing permissions. Through easy tables I have added a new column and specified "number" as datatype. Unfortunately this gets translated to MSSQL datatype float(53) or float(8) some tool shows me. If I want to do a bitwise search, I only get an error The expression 'this.hhIndex & 1'' is not supported.
I understand bitwise operations on float is not flying. I can use direct SQL statements, which works when casting the hhIndex above to INT. But, what options do I have to keep using easy tables and do bitwise search operations? I see this as a bug
I understand bitwise operations on float is not flying. I can use direct SQL statements, which works when casting the hhIndex above to INT. But, what options do I have to keep using easy tables and do bitwise search operations? I see this as a bug
Using EasyAuth for authentication works in our system. We have facebook and google login using android. We added google login to our iOS app, but having two platform logins for google seems not to be supported. How do we then make this work? I can't believe this is not suported
i am trying to insert a row but it isn't working for me
the error is
Invalid data type provided
I want to know if I could use Loopback.js (http://v4.loopback.io/) instead of express.
Loopback supports express middleware, so I would be using loopback to create all endpoints and connect all azure libraries to loopback.
I try to filter some data based on list of ids. But I can't find how to make my where() function use a list for a specific parameter. I know that I can use a function instead object as parameter for the where function but I don't know the prototype.
To be clearer, I try to use the SQL "IN" request.
To be clearer, I try to use the SQL "IN" request.