Forum

Hello
You get json data from the address written below. There is no problem when there is only one registration. But I cannot list many records. It gives an error "Object field not found (Key)". What do I have to do to list the records? Help please.

Code;
              Host     = "jsonplaceholder.typicode.com/";
          HTTPRequest = New HTTPRequest;
              // HTTPRequest.ResourceAddress = "todos/1";
               HTTPRequest.ResourceAddress = "photos/" ;// ThisObject.Attribute2;
               HTTPConnection         = New HTTPConnection(host,,,,,10,New OpenSSLSecureConnection);
               HTTPAnswer               = HTTPConnection.Get(HTTPRequest);
               stringAnswer= HTTPAnswer.GetBodyAsString();
               JSONReader = New JSONReader;
               JSONReader.SetString(stringAnswer);
               JsonResult = ReadJson(JSONReader,True);      

                For each strResult in JsonResult Do
                    If (strResult.Key = "url") Then
                        Message(strResult.Value);                                                  
                     EndIf;
               EndDo;

Hello Ertuğrul,

most likely the problem is that there are other fields in the structure you received, not just "Key".

To avoid the error, before executing the

If (strResult.Key ="url") Then

For each strResult in JsonResult Do
   If strResult.Property("Key") Then 
      If (strResult.Key = "url") Then
         Message(strResult.Value);                                                  
      EndIf;
   EndIf;
EndDo;

Hello,

This gave the error.
"Object method not found (Property)"

ok, then mail me please your source code and test account for "jsonplaceholder.typicode.com".

I'll deal with it

Aleksandr

My mail: abir@1c.com

Ertuğrul,

I understood where the bug is.

So your code should be like this:

   Host     = "jsonplaceholder.typicode.com/";
   HTTPRequest = New HTTPRequest;
   HTTPRequest.ResourceAddress = "photos/" ;
   HTTPConnection   = New HTTPConnection(host,,,,,10,New OpenSSLSecureConnection);
   HTTPAnswer      = HTTPConnection.Get(HTTPRequest);
   stringAnswer   = HTTPAnswer.GetBodyAsString();
   JSONReader       = New JSONReader;
   JSONReader.SetString(stringAnswer);
   JsonResult = ReadJson(JSONReader,True);      
   
   For each strResult in JsonResult Do
      For Each curElement In strResult Do 
         If (curElement.Key = "url") Then
            Message(curElement.Value);
            Break; // since the value curElement.Key = "url" can be only once, we can exit the loop
         EndIf;
      EndDo;
   EndDo;