📠Account Names to Facility Match using PeeringDB
This playbook uses Google Search, PeeringDB and TableOps
Business question: which organizations have data centers located in a given list of locations?
Playbook
Link to the playbook
Please pay attention to the spaces between words in each query. There must be only 1 blank space.
1. Search Google to get the correct organization names of the accounts
Cell 2 - Tool: Google Search
Search @1.AccountName on site peeringdb.com/org. If "organic" field has more than one item, then look at the first result. If the first result's title has " - " then return the text before " - ". Otherwise return empty. Cell 3 - Tool: TableOps
Remove rows where @2.search_account_on_peeringdb is empty. Changing column name @2.search_account_on_peeringdb to corrected_name and return the table.Note that in the table generated by the previous cell, the name of the column might be different, not "search_account_on_peeringdb". Use @ to get the right name.
2. Get organization id of the accounts
Cell 4 - Tool: PeeringDB
Get organization whose name contains @3.corrected_name. Sleep 3s between requests. Cell 5 - Tool: TableOps
Return a table with @4.AccountName , @4.corrected_name and org id with 1 org id per row. 3. Get network id of the accounts
Cell 6 - Tool: PeeringDB
Cell 7 - Tool: TableOps
4. Get facilities of the networks
Cell 8 - Tool: PeeringDB
Cell 9 - Tool: TableOps
5. Match the facility name with some facilities
Cell 10 - Tool: TableOps
Notes
When the number of rows is large, add this prompt to the query to avoid PeeringDB throttling error message.
"Sleep 3s between requests."
Last updated