iOS Question Connect to Azure

[Graeme Mitchell]

Hi, have searched to see if b4i can connect to Azure. I have downloaded sqljdbc_6.0 and I know I read somewhere I am supposed to put the sqljdbc42.jar file in th

 

[Erel]

Jar files are not related to B4i.

You need to connect to Azure through the REST API using iHttpUtils2.

 

[Graeme Mitchell]

Would you have any documentation on how I would get started?

 

[Erel]

You need to find the relevant Azure service documentation.

 

[Graeme Mitchell]

I setup everything with POSTMAN, so I have the access token etc. Would I use iHttpUtils2 and the httpjob?

 

[Erel]

Yes.

 

[Graeme Mitchell]

I have looked for hours through ever post and I am just not getting how to you use JSON/HTTPJOB to connect to AZURE

What I currently use in VB.NET is as follows (can someone translate for B4I?)

    Public Function Load_Data_Grid(ByRef Grid As DataGridView, ByRef table As String, ByRef filter As String)
        Dim myconnection As String
        Dim strSQL As String

        myconnection = "server=***********************;uid=********;pwd=r*******5;database=dbo.TCIC"
        Dim connection As New SqlConnection(myconnection)
        strSQL = "SELECT * FROM " & table
        Dim dataadapter As New SqlDataAdapter(strSQL, connection)
        Dim ds As New DataSet()
        connection.Open()
        dataadapter.Fill(ds, "QC_Data")
        Dim dv As DataView = New DataView(ds.Tables("QC_Data"))
        dv.RowFilter = "Machine = " & filter
        dv.Sort = "Id Asc"
        connection.Close()
        Grid.DataSource = dv
        If Grid.RowCount > 0 Then
            Grid.FirstDisplayedScrollingRowIndex = Grid.RowCount - 1
        End If
    End Function
[\code]

 

[Erel]

This is not a REST API. It will not work with http requests.

 

[Graeme Mitchell]

This is the Visual Basic code that I use, however, I am not sure how I would translate this into B4I and use the REST API. I guess I am looking for some guidance on how to do this. Please keep in mind I am new user to B4I

 

[Erel]

You cannot translate this code to iOS. Most of Azure services provide a REST API. You need to find it.

 

[Graeme Mitchell]

Can you give me an example of how a Azure or something similar REST API would look in B4I?

 

[Erel]

[B4X] OkHttpUtils2 with Wait For

 

[Graeme Mitchell]

So I have to do all of this Auth Tokens etc to simply read data from a table in Azure?

 

[Erel]

That depends on Azure requirements. I'm not familiar with them so cannot answer.

 

[Graeme Mitchell]

Firstly, thank you for being patient and answering my questions. I have found some connection strings but I am not sure if they would apply for B4I.

The connection strings are either ADO.NET, JDBC, ODBC or PHP. Could I use any of these with iHttpUtils2 and the httpjob?

 

[Erel]

No. The JDBC connection strings will work with B4J and B4A. They will not work with iOS (the programming language doesn't matter).