Sub ImportData(tablename As String, fromdate As String, todate As String)
'In order to make this work add "HU2_ACCEPTALL" to Build Configurations (CTRL+B)
Dim job As HttpJob
Dim odata As String
job.Initialize("", Me)
job.Username = "username"
job.Password = "password"
job.GetRequest.Timeout = 300000
Select Case tablename
Case "Sales"
odata = settings.Get("odata_import_sales")
odata = odata.Replace("INSERT_FROM_DATE_HERE", fromdate)
odata = odata.Replace("INSERT_TO_DATE_HERE", todate)
Log(odata)
End Select
Log("Request download " & tablename & ".")
job.Download(odata)
Wait For (job) JobDone(job As HttpJob)
If job.Success = True Then
File.Copy2(job.GetInputStream, File.OpenOutput(xui.DefaultFolder, tablename & "_" & fromdate & "_ " & todate & ".json", False))
Log(tablename & " downloaded.")
Else
Log("Something went wrong during download.")
End If
End Sub