PX Reader Node

Basic Information

Description	This node is used to get data from PX files
Input	pxconfig table
Output	One table
Usage Tags	READER , SOUCES

Node Settings

Data Set (string, required) : Data set url from pxconfig table
Table Name (string, required) : The name for the table that is generated from the node.

Tips and Advanced usage

First of all you need to add the configuration to the pxconfig table. It must contain at least the following columns:

DataSetUrl
DataSetName
JsonParameter
WebUrl

It is recommended that you first load pxconfig table into process context using SQL Query .

Examples

Example 1

Example configuration:

CODE

{
  "Url": "https://pxweb.stat.si:443/SiStatData/api/v1/sl/Data/0762003S.px",
  "TableName": "DelovnoSposobni"
}

Example 2

Pxconfig table fields:

DataSetUrl

DataSetName

JsonParameter

WebUrl

1

https://pxweb.stat.si:443/SiStatData/api/v1/sl/Data/0762003S.px

Delovno Sposobni

JSON

{
   "query":[
      {
         "code":"KOHEZIJSKA REGIJA",
         "selection":{
            "filter":"item",
            "values":[
               "1"
            ]
         }
      },
      {
         "code":"STAROSTNE SKUPINE",
         "selection":{
            "filter":"item",
            "values":[
               "0"
            ]
         }
      },
      {
         "code":"SPOL",
         "selection":{
            "filter":"item",
            "values":[
               "0"
            ]
         }
      },
      {
         "code":"MERITVE",
         "selection":{
            "filter":"item",
            "values":[
               "1100"
            ]
         }
      },
      {
         "code":"ČETRTLETJE",
         "selection":{
            "filter":"item",
            "values":[
               "2022Q3"
            ]
         }
      }
   ],
   "response":{
      "format":"csv"
   }
}

https://pxweb.stat.si/SiStatData/pxweb/sl/Data/-/0762003S.px/