Budget: 2000 UAH Deadline: 7 days
Hello, I created a similar parser for collecting companies from the registry by KVEDs: selection by activity code, extracting the name, EDRPOU, and phone number, recording directly into a Google Sheet on the required tab. I processed the mandatory phone field separately because it is not always returned cleanly in every record, and I cleaned duplicates.
If there are missing phone numbers in OpenDataBot for some records, it is worth immediately adding a collection from open sources by name or EDRPOU, which increases the completeness of the phone column by about 20-30%.
How many KVEDs are in the list and how many companies do you expect to get out, and is this a one-time parsing or do you need a regular run with table updates?
I suggest we get in touch; I will also outline a parser scheme for your KVED and Clients sheets, showing how the data will be structured.