New post
AllAccepted answers
Rochdi Badis · Jul 5, 2022

Thanks Robert but if you check my code above I already used csv and also tried 100 and still the same I get a tab delimited file rather than comma delimited that makes  the columns glued to each other as in all columns as in one column (see attached below)

see the file in a notepad

and also the double quotes doesn't seems to work, the heading still includes the datatype 

 Thanks

Rochdi Badis · May 27, 2022

I already did but with no luck.

But not sure why previous colleague hwo let the company is using %Net.MIMEPart, I haven't used this before I thought I need to send the JSON file is something like this:

 Set stream=##class(%FileBinaryStream).%New()
     Set stream.Filename=FilePath
     Do stream.LinkToFile(FilePath)
    if (CallbackHost ["VIBRA-API-DEV.AZUREWEBSITES.NET") {
    Set Httprequest=##class(%Net.HttpRequest).%New()
    Set Httprequest.SSLConfiguration="RTLS"
    Set Httprequest.Server="vibra-api-dev.azurewebsites.net"
    Set Httprequest.Timeout=30
    Set Httprequest.Https=1
    set Httprequest.ContentType="application/json"
    Do Httprequest.SetHeader("Accept","application/json")
    Do Httprequest.SetHeader("Accept-Language","en_US")
        Do Httprequest.SetHeader("Authorization","Bearer "_^Token)
     D Httprequest.EntityBody.Write(stream)
    Set tSc=Httprequest.Post("/API/SENSORS/VIBRATION")
    //S Out=Httprequest.HttpResponse.Data.ReadLine()
    Set StateCode=Httprequest.HttpResponse.StatusCode
    Quit StateCode

would this work?

thanks

Rochdi Badis · May 26, 2022

So in the future and in case I really need create a record with the same description on a unique indexed field, can I remove the UniqueIndex definition from the class definition do my change then put it back and compile rather than doing it through globals?

also when rebuilding indexes from SMP, it says running at the background but there no notification when the rebuild has finished, is there a way to see the running process because I couldn't see it in Processes?

Thanks

Rochdi Badis · May 24, 2022

what I sent is just a part of the full JSON as an example so it's not because it's missing part of it here is the full string, where I had to remove the brackets from beginning and end

 
JSON
Rochdi Badis · May 17, 2022

mybe you mean this  d ##class(%ZEN.Auxiliary.jsonProvider).%ConvertJSONToObject(SampleJsonData,,.list) ,I tried that but I got an empty list?

in all cases, after doing the below, I should be able at lease read the JSON string but I'm getting an html file, so I'm missing something in my code?  

set Httprequest = ##class(%Net.HttpRequest).%New()                   
Set Httprequest.SSLConfiguration="RTLS"                              
Set Httprequest.Server="serverurl"                 
Set Httprequest.Https=1                                              
Set Httprequest.Timeout=30                                           
set Httprequest.ContentType="application/json"                       
Do Httprequest.SetHeader("Accept","text/plain") set Httprequest.Username="user"                      
set Httprequest.Password="password"                              
S stat= Httprequest.Get("someurl")

Set Resp=Httprequest.HttpResponse.Data.Read()