Thanks Robert 

Thank you very much Eduard, but I'm wondering how does 1=1 would improve readability and help in debugging conditions in a query, isn't 1=1 just and extra condition itself ?

Thanks Eduard  

beside this, is there a way maybe in system management portal where you can check the number of code lines in each class, because reading the docs on how use Objectscript_Q is going to take me a long tine to figure and set it up in our system?

Thanks

Hm, according to the code, it did only go through 212 classes how come!?

Not really sure if it did return the right number!? I've created the method and returned only 64003 lines, knowing that in our system we have around 3021 class.

do you know what Size filed refers to, it's not the no of lines or the file size?

Thanks

I mean like this:

right click on a page, and as you can see properties 

and 

Thanks

Thanks but that will not return any records, knowing there a couple

repeating like this? didn't work

it looks like you're putting double quotes not two single quotes? 

I get 0 followed by some gibberish  as below, so I guess it's zero, which mean the post didn't go through, but how come it does from their portal (swagger) and our code use to work and we haven't change anything ? 

How to check the Status in tSc, tSc.StatusCode?

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

Hmmm,  I was able to connect to their dev server with no issues, not sure it they use the same server for both Dev & live environments !? 

is there a path or a hotfix that I can run to upgrade TLS because upgrading Ensemble is not an option for the time being?

Thanks

Thanks guys, CopyFrom saved the days 

Cheers all

Thanks Cristiano for you help.

By the way do I need to add :

D File.Open('R') before using  copy From  or just initialising the file is enough?

Thx

I mean, just to put it simple and foget my code, how would you a post HTTPREQUEST for a JSON file given a file path?

Thanks 

So should I me converting my file into a %GlobalBinaryStream ? how can Correct my code because I'm not sure where or how to use %Save()?

thanks

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