PX Reader Batch Node

Basic Information

Description	This node is used to get data from PX files
Input	pxconfig table
Output	Multiple tables
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:

JSON

{
  "Parameters": [
    {
      "Url": "https://pxweb.stat.si:443/SiStatData/api/v1/sl/Data/0762003S.px",
      "TableName": "delovnoSposobni"
    },
    {
      "Url": "https://pxweb.stat.si:443/SiStatData/api/v1/sl/Data/0762003S.px",
      "TableName": "dodanaVrednost"
    }
  ]
}

Example 2

Pxconfig table fields:

	DataSetUrl	DataSetName	JsonParameter	WebUrl
1	https://pxweb.stat.si:443/SiStatData/api/v1/sl/Data/0762003S.px	Delovno Sposobni	{ "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/
2	https://pxweb.stat.si:443/SiStatData/api/v1/sl/Data/0762003S.px	Dodana Vrednost	{ "query": [ { "code": "TRANSAKCIJE", "selection": { "filter": "item", "values": [ "A" ] } }, { "code": "MERITVE", "selection": { "filter": "item", "values": [ "V" ] } }, { "code": "VRSTA PODATKA", "selection": { "filter": "item", "values": [ "N" ] } }, { "code": "ČETRTLETJE", "selection": { "filter": "item", "values": [ "2022Q4" ] } } ], "response": { "format": "csv" } }	https://pxweb.stat.si/SiStatData/pxweb/sl/Data/-/0300220S.px/