This section handles the queries to Big Data.

GET /bigdata

This method returns the comined informacion about a process.

Request parameters:

    • company [mandatory]: The company name or id.
    • session [mandatory]: The Id of the active session.
    • datefrom [mandatory]: The starting date of the selection.
    • dateto [mandatory]: The ending date of the selection.
    • process: The Id of the process of whose data you want to show. If not indicated it shows all processes.

Response:

    • status: returns "0" on success, and an error code in any other case.
    • data: returns the big data inormation about the process.
    • message: "success" or a descriptive information of the error in any other case.

Ejemplo:

Request:

{"type":"get",

"url":"bigdata",

"data":"company=testco&session=GfZ0YWyyJCRTeRdQvOcvSTJYBzmnSCS70q9rQGb8zgrCykt7BMDhoRiRd16K&process=7201&datefrom=20201101060000&dateto=20201101140000"}


Reponse (success):

{"status":"0","data":[{"`DateTime`":"20201101060000","`Mach_Id`":"7201","`PN`":"","`Prod_Id`":"002R","`TSPR_Id_Author`":"","`TSPR_Created`":"","`TSPR_Id_Mod`":"","`TSPR_Modified`":"","`ProdType`":"0","`TiUs_Id`":"FAI","`Secs`":"28800","`TSTU_Id_Author`":"CENTRAL","`TSTU_Created`":"20201101162340","`TSTU_Id_Mod`":"CENTRAL","`TSTU_Modified`":"20201102131459","`TUType`":"3","`CycleT`":"15","`CycleQ`":"15","`Avai_Time`":"28800","`Prod_Time`":"0","`Total_Prod`":"0","`Theo_Prod`":"28800","`Tgt_Prod`":"0","`Green_Prod`":"14774,4000102997","`Yellow_Prod`":"10367,999879837","`Scrap_Prod`":"0","`Rework_Prod`":"0","`Good_Prod`":"0","`Availability`":"0","`Speed`":"0","`Quality`":"1","`OEE`":"0","`Shif_Id`":"4","`OperNames`":"","`TSPE_Id_Author`":"","`TSPE_Created`":"","`Team_Id`":"","`TSTE_Id_Author`":"","`TSTE_Created`":"","`TSPR_Comment`":"","`TSTU_Comment`":"","`TSPR_Id`":"","`TSTU_Id`":"20201101162340AAOCENTRAL","`TSPE_Id`":"","`TSTE_Id`":"","`Warn`":"","`Created`":"20201102135520"}],"message":"Success"}


Reponse (error):

{"status":1012,

"data":"<a href='http:\/\/127.0.0.1:8080\/edinnM2\/help\/en\/API_processes_state.html'>for additional information follow this link<\/a>",

"message":"Process not found"}

Let us see the description of each field:

  • DateTime: date and time of the record (in inverted format YYYYMMDDhhmmss).
  • Mach_Id: process identifier.
  • PN: identifier (OrderId) of the work order.
  • Prod_Id: result identifier.
  • TSPR_Id_Author: identifier of the resource which created the results record.
  • TSPR_Created: date and time of the creation of the results record (in inverted format YYYYMMDDhhmmss).
  • TSPR_Id_Mod: identifier of the resource which modified the results record.
  • TSPR_Modified: date and time of the modification of the results record (in inverted format YYYYMMDDhhmmss).
  • ProdType: type of the result.
  • TiUs_Id: identifier of the status.
  • Secs: seconds passed since previous record.
  • TSTU_Id_Author: identifier of the resource which created the status record.
  • TSTU_Created: date and time of the creation of the status record (in inverted format YYYYMMDDhhmmss).
  • TSTU_Id_Mod: identifier of the resource which modified the status record.
  • TSTU_Modified: date and time of the modification of the status record (in inverted format YYYYMMDDhhmmss).
  • TUType: type of the status.
  • CycleT: time in seconds per cycle of production.
  • CycleQ: quantity of results obtained every CycleT seconds.
  • Avai_Time: available time to produce in seconds.
  • Prod_Time: production time.
  • Total_Prod: total results.
  • Theo_Prod: results that could have been produced with the available time [(CycleQ / CycleT) * Avai_Time].
  • Tgt_Prod: results that could have been produced with the production time [(CycleQ / CycleT) * Prod_Time].
  • Green_Prod: first (green) target of results [Theo_Prod * 1er Obj. OEE].
  • Yellow_Prod: second (yellow) target of results [Theo_Prod * 2o Obj. OEE].
  • Scrap_Prod: scrap results.
  • Rework_Prod: reworked results.
  • Good_Prod: good results.
  • Availability: percentage (up to 1) of availability.
  • Speed: percentage (en tanto por 1) of speed.
  • Quality: percentage (en tanto por 1) of quality.
  • OEE: percentage (en tanto por 1) of OEE.
  • Shif_Id: shift identifier.
  • OperNames: identifiers, separated by commas, of the resources that were working.
  • TSPE_Id_Author: identifier of the resource which created the IN&OUT record of resources.
  • TSPE_Created: date and time of the creation of the IN&OUT record of resources (in inverted format YYYYMMDDhhmmss).
  • Team_Id: identifier of the team of resources.
  • TSTE_Id_Author: identifier of the resource which created the IN&OUT record of team of resources.
  • TSTE_Created: date and time of the creation of the IN&OUT record of team of resources (in inverted format YYYYMMDDhhmmss).
  • TSPR_Comment: comment inserted in the result.
  • TSTU_Comment: comment inserted in the status.
  • TSPR_Id: internal identifier of the results record.
  • TSTU_Id: internal identifier of the status record.
  • TSPE_Id: internal identifier of the IN&OUT resouces record.
  • TSTE_Id: internal identifier of the IN&OUT team of resouces record.
  • Warn: warnings generated by the system for this record.
  • Created: date and time of the creation of this record (in inverted format YYYYMMDDhhmmss).