powershell - Nested arrays and ConvertTo-Json -

-

to use rest api, must pass json object looks this:

{ "series" :    [{         "metric": "custom.powershell.gauge",       "points":[[1434684739, 1000]]     }   ] }

note nested array here. cannot reproduce this. here code:

[int][double]$unixtime=get-date ( (get-date).touniversaltime() ) -uformat %s $obj=@{} $series=@{} $array=@() $points=@() $value=get-random -minimum 0 -maximum 100   $series.add("metric","custom.powershell.gauge") $points=@(@($unixtime, $value)) $series.add("points",$points) $obj.add("series",@($series))  $json=$obj | convertto-json -depth 30 -compress $json

and here output: 

{"series":[{"points":[1434685292,95],"metric":"custom.powershell.gauge"}]}

i've tried many things, cannot 2 arrays nested, end looking single array.

on same note, came explain please:

> $a=(1,2) > $a 1 2 > $a | convertto-json [     1,     2 ] > $b=($a,$a) > $b 1 2 1 2 > $b | convertto-json [     {         "value":  [                       1,                       2                   ],         "count":  2     },     {         "value":  [                       1,                       2                   ],         "count":  2     } ]

where these value , count coming from?

thanks help.

the explanation (1,2),(3,4) array of array, powershell split first level pipe |, , don't give name these arrays serializer supplies it. first have try :

# first build array of array $z = (1,2),(3,4) # convert json using , ,$z | convertto-json -depth 5 -compress [psobject]@{"points"=$z} | convertto-json -depth 5 -compress

it gives first step:

{"value":[[1,2],[3,4]],"count":2} {"points":[[1,2],[3,4]]}

now solution propose :

# first build array of array $z = (1,2),(3,4)  # build pscustom object $a = [pscustomobject]@{"series" = ,@{"metric"="custom.powershell.gauge"; "points"=$z}}  # @ end convert json # don't forget **depth** parameter (use **compress** retreive 1 line above) $a | convertto-json -depth 5

for me gives close need:

{     "series":  [                    {                        "points":  [                                       [                                           1,                                           2                                       ],                                       [                                           3,                                           4                                       ]                                   ],                        "metric":  "custom.powershell.gauge"                    }                ] }

Comments

Post a Comment

Popular posts from this blog

python - How to create jsonb index using GIN on SQLAlchemy? -

-
here's current code creating index jsonb. index("mytable_data_idx_id_key", mytable.data['id'].astext, postgresql_using='gin') but got error. sqlalchemy.exc.programmingerror: (psycopg2.programmingerror) data type text has no default operator class access method "gin" hint: must specify operator class index or define default operator class data type. [sql: "create index event_data_idx_id_key on event using gin ((data ->> 'id'))"] is there way create index on sqlalchemy? the postgresql specific sqlalchemy docs @ http://docs.sqlalchemy.org/en/latest/dialects/postgresql.html#operator-classes mention postgresql_ops dictionary provide "operator class" used postgresql, , provide example illustrating use: index('my_index', my_table.c.id, my_table.c.data, postgresql_ops={ 'data': 'text_pattern_ops', ...
Read more

PHP DOM loadHTML() method unusual warning -

-
i had following code works fine on localhost: $document = new domdocument(); $document->loadhtml($p_result); $form = $document->getelementsbytagname('form')->item(0); // code continues using $form variable after same code updated on outside server, loadhtml() failed , issued warning. warning: domdocument::loadhtml() expects parameter 1 valid path, string given in path/name/to/script.php returned null instead of object code pretty gets fatal error. note contents of $p_result absolutely same on outside server , on localhost. but why displays kind of warning , why not work? doesn't loadhtml() expects argument 1 string in first place? why method expects parameter 1 valid path ? just make clear i'm not calling loadhtmlfile() , i'm calling loadhtml() . thanks. you're affected one of php bugs . issue present in php 5.6.8 , 5.6.9. have affected php version on server, , bug-free version on localhost. the bug forbids null ...
Read more

c# - TransactionScope not rolling back although no complete() is called -

-
i'm using transactionscope rollback transaction fail bool errorreported = false; action<importerrorlog> newerrorcallback = e => { errorreported = true; errorcallback(e); }; using (var transaction = new transactionscope()) { foreach (importtaskdefinition task in taskdefinition) { loader.load(streamfile, newerrorcallback, task.destinationtable, processingtaskid); } if (!errorreported) transaction.complete(); } i'm sure there no transactionscope started ahead or after code. i'm using entity framework insert in db. regardless state of errorreported transaction never rolled in case of error. what missing ? transactionscope sets transaction.current . that's does. wants transacted must @ property. i believe ef each time connection opened reason. probably, connection open when scope installed. open connection inside of scope or enlist manually. ef has nasty "design decision": default opens ...
Read more