Forum Discussion

bastian_mpnkt's avatar
bastian_mpnkt
New Member
8 years ago
Solved

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

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
Need Help
Show and Tell
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    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

2 Replies

Replies have been turned off for this discussion
  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    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