streaming dataset(REST API) multiple values as object or array

[bastian_mpnkt]

Hi everbody

i have a problem and i hope that you could support me.

I create a new streaming Dataset( REST API):

[

{

"id" :"AAAAA555555",

"cycle_value" :98.6,

"timestampe" :"2018-07-27T10:21:44.883Z",

"current" :98.6,

"speed" :98.6

}

]

And the body for the streamind Dataset looks like:

"{
     "current": {
          "rd25": "#%-ItemValue%TB6.PLC_1.Inputs.Current1(7)_Subscription_1000%Current-%#",
          "rd26": "#%-ItemValue%TB6.PLC_1.Inputs.Current2(7)_Subscription_1000%Current-%#",
          "rd27": "#%-ItemValue%TB6.PLC_1.Inputs.Current3(7)_Subscription_1000%Current-%#",
          "rd28": "#%-ItemValue%TB6.PLC_1.Inputs.Current4(7)_Subscription_1000%Current-%#"
      },
        "id":  {
          "rd25": "rd_25",
          "rd26": "rd_26",
          "rd27": "rd_27",
          "rd28": "rd_28"
      },
     "speed": "#%-ItemValue%TB6.PLC_1.Inputs.Speed Motor 4(7)_Subscription_1000%Current-%#",
     "timestampe": "#%-ItemValue%TB6.Server.ServerStatus.CurrentTime_Subscription_1000%Current-%#",
     "cycle_value": "#%-ItemValue%TB6.PLC_1.DataBlocksGlobal.counter_Db.dc1_count_1_Subscription_1000%Current-%#",
}

 "

But I only receive data from "speed","timestampe" and "cycle_value".

So there is a problem with the declariation for "current" and "id".

I tried to implement this mutltiple values as an object { } and as an array[ ]. Booth ways didn´t work.

I hope you can help me.

Many thanks in advance.

Best regards

bastian

[v-jiascu-msft · Accepted solution]

Hi Bastian,

The format should be like the demo. So it should be like below taking your data as an example.

[
{
"id" :"AAAAA555555",
"cycle_value" :98.6,
"timestampe" :"2018-07-27T10:21:44.883Z",
"current" :98.6,
"speed" :98.6
},
{
"id" :"AAAAA555555",
"cycle_value" :98.6,
"timestampe" :"2018-07-27T10:21:44.883Z",
"current" :98.6,
"speed" :98.6
}
]

[
{
     "current": "#%-ItemValue%TB6.PLC_1.Inputs.Current1(7)_Subscription_1000%Current-%#",
        "id":   "rd_25",
     "speed": "#%-ItemValue%TB6.PLC_1.Inputs.Speed Motor 4(7)_Subscription_1000%Current-%#",
     "timestampe": "#%-ItemValue%TB6.Server.ServerStatus.CurrentTime_Subscription_1000%Current-%#",
     "cycle_value": "#%-ItemValue%TB6.PLC_1.DataBlocksGlobal.counter_Db.dc1_count_1_Subscription_1000%Current-%#",
},
{
     "current": "#%-ItemValue%TB6.PLC_1.Inputs.Current2(7)_Subscription_1000%Current-%#",
        "id": "rd_26",
     "speed": "#%-ItemValue%TB6.PLC_1.Inputs.Speed Motor 4(7)_Subscription_1000%Current-%#",
     "timestampe": "#%-ItemValue%TB6.Server.ServerStatus.CurrentTime_Subscription_1000%Current-%#",
     "cycle_value": "#%-ItemValue%TB6.PLC_1.DataBlocksGlobal.counter_Db.dc1_count_1_Subscription_1000%Current-%#",
},
{
     "current": "#%-ItemValue%TB6.PLC_1.Inputs.Current3(7)_Subscription_1000%Current-%#",
        "id": "rd_27",
     "speed": "#%-ItemValue%TB6.PLC_1.Inputs.Speed Motor 4(7)_Subscription_1000%Current-%#",
     "timestampe": "#%-ItemValue%TB6.Server.ServerStatus.CurrentTime_Subscription_1000%Current-%#",
     "cycle_value": "#%-ItemValue%TB6.PLC_1.DataBlocksGlobal.counter_Db.dc1_count_1_Subscription_1000%Current-%#",
},
{
     "current":"#%-ItemValue%TB6.PLC_1.Inputs.Current4(7)_Subscription_1000%Current-%#",
        "id":  "rd_28",
     "speed": "#%-ItemValue%TB6.PLC_1.Inputs.Speed Motor 4(7)_Subscription_1000%Current-%#",
     "timestampe": "#%-ItemValue%TB6.Server.ServerStatus.CurrentTime_Subscription_1000%Current-%#",
     "cycle_value": "#%-ItemValue%TB6.PLC_1.DataBlocksGlobal.counter_Db.dc1_count_1_Subscription_1000%Current-%#",
}
]

Best Regards,

Dale

[bastian_mpnkt]

Hi Dale,

it works. Thank you.

Best regards

bastian