TIA Portal Data Extraction to JSON

The End of Manual Exports

Extracting a list of 500 tags from TIA Portal to Excel is a chore. With T-IA Connect, you can transform any Data Block (DB) or Tag Table into a structured JSON object in a single API request.

Step 1: List Variables (Tags)

To retrieve an entire tag table, use the /api/tags endpoint. You will receive an array of objects containing the name, address, data type, and comment.

[
  {
    "name": "Main_Conveyor_Start",
    "address": "%I0.0",
    "dataType": "Bool",
    "comment": "Start button for the main conveyor"
  },
  {
    "name": "Emergency_Stop",
    "address": "%I0.1",
    "dataType": "Bool",
    "comment": "Safety E-Stop"
  }
]

Step 2: Export a Data Block (DB)

TIA Connect can read the internal structure of DBs, even nested structures and arrays. This is ideal for generating configuration files automatically.

{
  "blockName": "DB_Config",
  "members": [
    { "name": "MaxSpeed", "type": "Real", "value": 1500.0 },
    { "name": "IsActive", "type": "Bool", "value": true },
    { "name": "Parameters", "type": "Struct", "members": [...] }
  ]
}

Step 3: Conversion to Excel/CSV

Once you have the JSON, it is trivial to convert it to Excel via a simple Python script or an online tool.