Gus

Description of Formula:
Returns information about company taken from Głównego Urzędu Statystycznego (Central Statistical Office)

External data sources
Function uses API of Główny Urząd Statystyczny, so data are taken from external source. Function will start working when you open admin and External Data Sources tab, choose source you want and turn on. To do this, you need to check Enabled and enter the token. You can get the token from Główny Urząd Statystyczny, instruction and website here - https://api.stat.gov.pl/Home/RegonApi#menu2
Remark: IP address, which you will need for registration, you can get here: https://dns.google.com/

Where can you use Gus formula?
1) Table and Spreadsheet section
To fill section with data:
– enter Gus formula in the „Filter” section’s property
– use field from data source in at least one of the section’s columns
Syntax:
Gus(nip | nip_array)
Parameters:
Nip
(type: text) Number NIP of company, for which you want take data
Nip_array
(type: text) Address of an editable table column, in which nip numbers will be entered (for the table section, the table will display data for all nip numbers in the table)
Returned type:
Record
Examples:
=Gus('5261040828')

2) Cell of Table or Spreadsheet
Syntax:
Gus(nip,identifier)
Parameters:
nip
(type: text) Number NIP of company, for which you want take data
identifier
(type: identifier) Identifier of one of the fields returned by Gus (Fields, you can find in tab data after expand _EXT_GUS)
Returned type:
Text
Examples:
=Gus('5261040828',NAZWA)
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk