wd-gdocs-addons

A set of scripts that make life easier and work with the data of employees & volunteer & members of the Citizens Network Watchdog Poland

Repository consists:

• addon - GSuite extensions
• app - NodeJS API to expose unpublic data

Available functions

GovDataByRegon

Arguments:

• REGON – determines institution ID
• any of following – name, nip, regon14, regon9, regon, postal_code, city, voivodeship, community, county, street, house_no, flat_no, teryt – determines returned data, name by default

Examples

Value:

=GovDataByRegon('000678239')

Output:

Bałtycka Galeria Sztuki Współczesnej w Słupsku

Values:

=GovDataByRegon("000678239";"teryt")

Output:

0977278

Alternatives

• GovDataByNip function is also available. The signature is identical, except first argument is NIP.

FederByRegon

Arguments:

• REGON – determines institution ID
• any of following – name, regon,id – determines returned data, name by default

Examples

Values:

=FederByRegon('000678239');

Output:

Bałtycka Galeria Sztuki Współczesnej w Słupsku