cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
bastian_mpnkt Frequent Visitor
Frequent Visitor

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
1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

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

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team
Community Support Team

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

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
bastian_mpnkt Frequent Visitor
Frequent Visitor

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

Hi Dale,

 

it works. Thank you.

 

Best regards

bastian