Hi All,

   Request your help, the below code is working but we need the output as a json array, in PHP we have json_encode(content), so how to do the same in D, the output is as below, as we need to store this output into database table which contains columns' (Id, Hostname, pool,email_id,username)

*******************
PHP
$jdata = json_encode(content);
foreach($jdata as $j) {
print_r($j["items"]["hostname"]);
*****************

OUTPUT:
{"items":
	[
		{"id":"1",
		"hostname":"server1",
		"pool":"dev",
		"options":[
			{"optionValue":"test1@mail.com,test1"},
			{"optionValue":"123"}
			]
		},
		{"id":"2",
		"hostname":"server2",
		"pool":"dev",
		"options":[
			{"optionValue":"test2@mail.com,test2"},
			{"optionValue":"124"}
			]
		}
	]
}

import std.net.curl, std.conv, std.stdio, std.json;

void main() {
auto https = HTTP();
https.handle.set(CurlOption.userpwd, "user:pass");
https.handle.set(CurlOption.connecttimeout, 600);
https.handle.set(CurlOption.tcp_nodelay, 1);
https.handle.set(CurlOption.buffersize, 1073741824);
https.handle.set(CurlOption.http_version, 2);
https.handle.set(CurlOption.sslversion,  1);
https.handle.set(CurlOption.use_ssl,  3);
https.handle.set(CurlOption.ssl_verifypeer, 0);
https.handle.set(CurlOption.url, "https://test.com/userlist");
https.method(HTTP.Method.get);
https.StatusLine status;
https.onReceiveStatusLine = (https.StatusLine s) { status = s; };
auto content = https.perform();
https.shutdown;
writeln(to!string(content));
}

From,
Vino.B

On Friday, 2 October 2020 at 21:12:09 UTC, Vino wrote:
> Hi All,
>
>    Request your help, the below code is working but we need the output as a json array, in PHP we have json_encode(content), so how to do the same in D, the output is as below, as we need to store this output into database table which contains columns' (Id, Hostname, pool,email_id,username)
>
> [...]

JSONValue jv = parseJSON(content);

On Friday, 2 October 2020 at 21:12:09 UTC, Vino wrote:
> Hi All,
>
>    Request your help, the below code is working but we need the output as a json array, in PHP we have json_encode(content), so how to do the same in D, the output is as below, as we need to store this output into database table which contains columns' (Id, Hostname, pool,email_id,username)
>
> [...]

I also suggest you take a look at other "json packages" as well:
https://code.dlang.org/search?q=json

For example std_data_json or asdf

On Friday, 2 October 2020 at 23:20:48 UTC, Imperatorn wrote:
> On Friday, 2 October 2020 at 21:12:09 UTC, Vino wrote:
>> Hi All,
>>
>>    Request your help, the below code is working but we need the output as a json array, in PHP we have json_encode(content), so how to do the same in D, the output is as below, as we need to store this output into database table which contains columns' (Id, Hostname, pool,email_id,username)
>>
>> [...]
>
> I also suggest you take a look at other "json packages" as well:
> https://code.dlang.org/search?q=json
>
> For example std_data_json or asdf

Hi,

 I tired sdt_data_json, still no luck, the output of the url is as below

Output : {"Name":"testuser","Site":"1-east"}

Error :
test.d(20): Error: template `stdx.data.json.parser.parseJSONValue` cannot deduce function from argument types `!()(int)`, candidates are:
C:\D\dmd2\windows\bin\..\..\src\phobos\stdx\data\json\parser.d(133):        `parseJSONValue(LexOptions options = LexOptions.init, Input)(ref Input input, string filename = "", int maxDepth = defaultMaxDepth)`
  with `options = cast(LexOptions)0,
       Input = int`
  whose parameters have the following constraints:
  `~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~`
`  > isInputRange!Input
      - isSomeChar!(ElementType!Input)
        or:
      - isIntegral!(ElementType!Input)
`  `~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~`
C:\D\dmd2\windows\bin\..\..\src\phobos\stdx\data\json\parser.d(178):        `parseJSONValue(Input)(ref Input tokens, int maxDepth = defaultMaxDepth)`
  with `Input = int`
  whose parameters have the following constraints:
  `~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~`
`  > isJSONTokenInputRange!Input
`  `~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~`
datacoll.d(20):        All possible candidates are marked as `deprecated` or `@disable`
  Tip: not satisfied constraints are marked with `>`

Code:
import std.net.curl, std.conv, std.stdio, stdx.data.json;


void main() {
auto https = HTTP();
https.handle.set(CurlOption.userpwd, "user:pass");
https.handle.set(CurlOption.connecttimeout, 600);
https.handle.set(CurlOption.tcp_nodelay, 1);
https.handle.set(CurlOption.buffersize, 1073741824);
https.handle.set(CurlOption.http_version, 2);
https.handle.set(CurlOption.sslversion,  1);
https.handle.set(CurlOption.use_ssl,  3);
https.handle.set(CurlOption.ssl_verifypeer, 0);
https.handle.set(CurlOption.url, "https://test.com/getUser");
https.method(HTTP.Method.get);
https.StatusLine status;
auto content = https.perform();
https.shutdown;
JSONValue jv = parseJSONValue(content);
writeln(jv["Name"]);

}

From,
Vino

On Friday, 9 October 2020 at 01:45:37 UTC, Vino wrote:
> On Friday, 2 October 2020 at 23:20:48 UTC, Imperatorn wrote:
>> On Friday, 2 October 2020 at 21:12:09 UTC, Vino wrote:
>>> Hi All,
...
> auto content = https.perform();
> https.shutdown;
> JSONValue jv = parseJSONValue(content);

Maybe
JSONValue jv = toJSONValue(content);


> writeln(jv["Name"]);
>
> }
>
> From,
> Vino

On Friday, 9 October 2020 at 05:30:34 UTC, ikod wrote:
> On Friday, 9 October 2020 at 01:45:37 UTC, Vino wrote:
>> On Friday, 2 October 2020 at 23:20:48 UTC, Imperatorn wrote:
>>> On Friday, 2 October 2020 at 21:12:09 UTC, Vino wrote:
>>>> Hi All,
> ...
>> auto content = https.perform();
>> https.shutdown;
>> JSONValue jv = parseJSONValue(content);
>
> Maybe
> JSONValue jv = toJSONValue(content);
>
>
>> writeln(jv["Name"]);
>>
>> }
>>
>> From,
>> Vino

Hi Ikod,

  No luck.

Error
test.d(19): Error: template `stdx.data.json.parser.toJSONValue` cannot deduce function from argument types `!()(int)`, candidates are:
C:\D\dmd2\windows\bin\..\..\src\phobos\stdx\data\json\parser.d(58):        `toJSONValue(LexOptions options = LexOptions.init, Input)(Input input, string filename = "", int maxDepth = defaultMaxDepth)`
  with `options = cast(LexOptions)0,
       Input = int`
  whose parameters have the following constraints:
  `~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~`
`  > isInputRange!Input
      - isSomeChar!(ElementType!Input)
        or:
      - isIntegral!(ElementType!Input)
`  `~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~`
C:\D\dmd2\windows\bin\..\..\src\phobos\stdx\data\json\parser.d(65):        `toJSONValue(Input)(Input tokens, int maxDepth = defaultMaxDepth)`
  with `Input = int`
  whose parameters have the following constraints:
  `~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~`
`  > isJSONTokenInputRange!Input
`  `~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~`
datacoll.d(19):        All possible candidates are marked as `deprecated` or `@disable`
  Tip: not satisfied constraints are marked with `>`

From,
Vino

On Friday, 9 October 2020 at 05:56:05 UTC, Vino wrote:
> On Friday, 9 October 2020 at 05:30:34 UTC, ikod wrote:
>> On Friday, 9 October 2020 at 01:45:37 UTC, Vino wrote:
>>> On Friday, 2 October 2020 at 23:20:48 UTC, Imperatorn wrote:
>>>> On Friday, 2 October 2020 at 21:12:09 UTC, Vino wrote:
>>>>> Hi All,
>> ...
>>> auto content = https.perform();
>>> https.shutdown;
>>> JSONValue jv = parseJSONValue(content);
>>
>> Maybe
>> JSONValue jv = toJSONValue(content);
>>
>>
>>> writeln(jv["Name"]);
>>>
>>> }
>>>
>>> From,
>>> Vino
>
> Hi Ikod,
>
>   No luck.
>
> Error
> test.d(19): Error: template `stdx.data.json.parser.toJSONValue` cannot deduce function from argument types `!()(int)`, candidates are:
> C:\D\dmd2\windows\bin\..\..\src\phobos\stdx\data\json\parser.d(58):        `toJSONValue(LexOptions options = LexOptions.init, Input)(Input input, string filename = "", int maxDepth = defaultMaxDepth)`
>   with `options = cast(LexOptions)0,
>        Input = int`
>   whose parameters have the following constraints:
>   `~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~`
> `  > isInputRange!Input
>       - isSomeChar!(ElementType!Input)
>         or:
>       - isIntegral!(ElementType!Input)
> `  `~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~`
> C:\D\dmd2\windows\bin\..\..\src\phobos\stdx\data\json\parser.d(65):        `toJSONValue(Input)(Input tokens, int maxDepth = defaultMaxDepth)`
>   with `Input = int`
>   whose parameters have the following constraints:
>   `~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~`
> `  > isJSONTokenInputRange!Input
> `  `~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~`
> datacoll.d(19):        All possible candidates are marked as `deprecated` or `@disable`
>   Tip: not satisfied constraints are marked with `>`
>
> From,
> Vino

(Writing from my mobile, a lot of room for improvements):

import std.net.curl, std.stdio;

// GET with custom data receivers
auto http = HTTP("dlang.org");
http.onReceiveHeader =
    (in char[] key, in char[] value) { writeln(key, ": ", value); };

ubyte[] content;
http.onReceive = (ubyte[] data) {
content ~= data;
return data.length; };
http.perform();

string s = cast(string) content;

Kind regards
Andre

On Friday, 9 October 2020 at 17:50:16 UTC, Andre Pany wrote:
> On Friday, 9 October 2020 at 05:56:05 UTC, Vino wrote:
>> On Friday, 9 October 2020 at 05:30:34 UTC, ikod wrote:
>>> On Friday, 9 October 2020 at 01:45:37 UTC, Vino wrote:
>>>> On Friday, 2 October 2020 at 23:20:48 UTC, Imperatorn wrote:
>>>>> On Friday, 2 October 2020 at 21:12:09 UTC, Vino wrote:
>>>>>> Hi All,
>>> ...
>>>> auto content = https.perform();
>>>> https.shutdown;
>>>> JSONValue jv = parseJSONValue(content);
>>>
>>> Maybe
>>> JSONValue jv = toJSONValue(content);
>>>
>>>
>>>> writeln(jv["Name"]);
>>>>
>>>> }
>>>>
>>>> From,
>>>> Vino
>>
>> Hi Ikod,
>>
>>   No luck.
>>
>> Error
>> test.d(19): Error: template `stdx.data.json.parser.toJSONValue` cannot deduce function from argument types `!()(int)`, candidates are:
>> C:\D\dmd2\windows\bin\..\..\src\phobos\stdx\data\json\parser.d(58):        `toJSONValue(LexOptions options = LexOptions.init, Input)(Input input, string filename = "", int maxDepth = defaultMaxDepth)`
>>   with `options = cast(LexOptions)0,
>>        Input = int`
>>   whose parameters have the following constraints:
>>   `~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~`
>> `  > isInputRange!Input
>>       - isSomeChar!(ElementType!Input)
>>         or:
>>       - isIntegral!(ElementType!Input)
>> `  `~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~`
>> C:\D\dmd2\windows\bin\..\..\src\phobos\stdx\data\json\parser.d(65):        `toJSONValue(Input)(Input tokens, int maxDepth = defaultMaxDepth)`
>>   with `Input = int`
>>   whose parameters have the following constraints:
>>   `~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~`
>> `  > isJSONTokenInputRange!Input
>> `  `~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~`
>> datacoll.d(19):        All possible candidates are marked as `deprecated` or `@disable`
>>   Tip: not satisfied constraints are marked with `>`
>>
>> From,
>> Vino
>
> (Writing from my mobile, a lot of room for improvements):
>
> import std.net.curl, std.stdio;
>
> // GET with custom data receivers
> auto http = HTTP("dlang.org");
> http.onReceiveHeader =
>     (in char[] key, in char[] value) { writeln(key, ": ", value); };
>
> ubyte[] content;
> http.onReceive = (ubyte[] data) {
> content ~= data;
> return data.length; };
> http.perform();
>
> string s = cast(string) content;
>
> Kind regards
> Andre

Hi Andre,

  Thank you very much, now we are able to get the data as expected using jv["Name"], now when we try to print all the returned data with Key and Values as below it is thorwing an error

Error:

Error: template `object.byKeyValue` cannot deduce function from argument types `!()(JSONValue)`

Code:

string s = cast(string) content;
JSONValue jv = parseJSONValue(s);
writeln(jv["Name"];               \\ this works.
foreach (key, value; jv.byKeyValue) writefln("%s: %s", key, value);  \\ this does not work.

From,
Vino

On Sunday, 11 October 2020 at 08:48:16 UTC, Vino wrote:
> On Friday, 9 October 2020 at 17:50:16 UTC, Andre Pany wrote:
>> [...]
>
> Hi Andre,
>
>   Thank you very much, now we are able to get the data as expected using jv["Name"], now when we try to print all the returned data with Key and Values as below it is thorwing an error
>
> Error:
>
> Error: template `object.byKeyValue` cannot deduce function from argument types `!()(JSONValue)`
>
> Code:
>
> string s = cast(string) content;
> JSONValue jv = parseJSONValue(s);
> writeln(jv["Name"];               \\ this works.
> foreach (key, value; jv.byKeyValue) writefln("%s: %s", key, value);  \\ this does not work.
>
> From,
> Vino

As far as I remember:
foreach (key, value; jv.object.byKeyValue)

byKeyValue is a function of an associative array. You get the associative array (Json object) of an JSONValue by attribute .object.

Kind regards
Andre