Retrieve URL of all Knack Apps

If you need a list of knack applications, you can retrieve them from the console when signed into the builder.

Original Code: https://gist.github.com/ktaranov/41f32478f701d8cdb598efbbf70e379e

Steps to retrieve all URLs of Knack applications

1

Sign-In to Knack dashboard

Go to https://dashboard.knack.com/

If you are signed in as the Transportation Data service account, it will retrieve all knack applications including test applications and sandbox.

If you are signed-in as a builder, it will show all applications that are shared to you.

2

Copy/Paste the code below into the console

1. Right-click web page - > Inspect

2. Navigate to Console tab - > Copy/Paste JS code below using the "Copy" button on top right corner of code block and press Enter

   1. NOTE: If a warning shows up you may have to write allow pasting if the browser console will not let you.

3. Highlight the entire table in the console and right click > Copy

From there, the index, Application Name, and URL will be saved on your clipboard and you can put it in a spreadsheet or note document.

3

Optional: Format URL links in Excel

When you post your clipboard to an Excel document, the URLs will be wrapped in single quotes. You can make them functional hyperlink in excel using this excel formula below.

=HYPERLINK(SUBSTITUTE(D2,"'",""),"Builder")

=HYPERLINK(SUBSTITUTE(E2,"'",""),"Live App")

It should look something like this:

JavaScript

There are two types of URLs you can retrieve with this code, the builder URL or the URL home page. You may select either one of the tabs based on your preference.

• Live App URL: Retrieves URL that starts with https://atd.knack.com/

• Builder URL: Retrieves URL that starts with https://builder.knack.com/atd/

• Both + Records: Retrieve App Name, total # of records, Builder URL, and Live app URL

  • This is the most up to date

Live App URL

let x = document.querySelectorAll("a");
let builderLink = "https://builder.knack.com/atd/";
let knackLink = "https://atd.knack.com/";
let myarray = [];
for (let i = 0; i < x.length; i++) {
    let nametext = x[i].textContent;
    let cleantext = nametext.replace(/\s+/g, " ").trim();
    let cleanlink = x[i].href;
    if (cleanlink.includes(builderLink) && cleantext.length > 0) {
      // Replaces Builder URL with Home Page URL  
      cleanlink = cleanlink.replace(builderLink, knackLink)
      myarray.push([cleantext, cleanlink]);
    }
}
console.table(myarray);

Builder URL

let x = document.querySelectorAll("a");
let builderLink = "https://builder.knack.com/atd/";
let myarray = [];
for (let i = 0; i < x.length; i++) {
    let nametext = x[i].textContent;
    let cleantext = nametext.replace(/\s+/g, " ").trim();
    let cleanlink = x[i].href;
    if (cleanlink.includes(builderLink) && cleantext.length > 0) {
      myarray.push([cleantext, cleanlink]);
    }
}
console.table(myarray);

Both + Records

// Retrieve relevent fields in Knack Dashboard
let appNameFields = document.querySelectorAll(`a[data-testid="apps-table-app-name-field"]`); // Gets App Name
let appRecordFields = document.querySelectorAll(`div[data-testid="apps-table-app-records-count"] 
> div[data-testid="asterisk-tooltip-trigger"]`); // Gets record text
let appStorageFields = document.querySelectorAll(`div[data-testid="apps-table-app-storage-count"]
> div[data-testid="asterisk-tooltip-trigger"]`); // Gets storage text
let appBuilderUrls = document.querySelectorAll(`a[aria-label="App builder"]`); // Gets builder Url
let appLiveUrls = document.querySelectorAll(`a[aria-label="Live app"]`); // Gets live Url
let myarray = [];

// Add to array the following fields
for (let i = 0; i < appNameFields.length; i++) {
    let nameAppText = appNameFields[i].innerText;
    let recordText = appRecordFields[i].innerText;
    let builderUrl = appLiveUrls[i].href;
    let liveUrl = appLiveUrls[i].href;
    // To do - In the future pull storage data text as a number and whether it is MB/GB
    myarray.push({
	    "Application Name": nameAppText, 
	    "Records": Number(recordText),
	    "Builder": builderUrl,
	    "Live App": liveUrl
    });
}

console.table(myarray);