thedward · July 11, 2024 19:39
diff --git a/01-scrape-airtable-schema.js b/01-scrape-airtable-schema.js
 (function () {
  //-------------------------------------------------------------------------------------------------------------------------
  // To use this script, go the the API page for your Airtable Base (something like https://airtable.com/<base_id>/api/docs).
  // Then, open the javascript console (F12) on Chrome. Then copy this script and paste it into the console (and hit Enter).
  // The schema serialized as JSON should now be in your clipboard.
  //
  // Alternatively, you can use the bookmarklet below.
  //-------------------------------------------------------------------------------------------------------------------------
  
  // ------------------------------------------------------------------------------------------------
  // copyToClipboard implementation via:
  // <https://gist.github.com/Chalarangelo/4ff1e8c0ec03d9294628efbae49216db/#file-copytoclipboard-js>
  // ------------------------------------------------------------------------------------------------
  
  const copyToClipboard = str => {
    const el = document.createElement('textarea');  // Create a <textarea> element
    el.value = str;                                 // Set its value to the string that you want copied
    el.setAttribute('readonly', '');                // Make it readonly to be tamper-proof
    el.style.position = 'absolute';                 
    el.style.left = '-9999px';                      // Move outside the screen to make it invisible
    document.body.appendChild(el);                  // Append the <textarea> element to the HTML document
    const selected =            
      document.getSelection().rangeCount > 0        // Check if there is any content selected previously
      ? document.getSelection().getRangeAt(0)     // Store selection if found
      : false;                                    // Mark as false to know no selection existed before
    el.select();                                    // Select the <textarea> content
    document.execCommand('copy');                   // Copy - only works as a result of a user action (e.g. click events)
    document.body.removeChild(el);                  // Remove the <textarea> element
    if (selected) {                                 // If a selection existed before copying
      document.getSelection().removeAllRanges();    // Unselect everything on the HTML document
      document.getSelection().addRange(selected);   // Restore the original selection
    }
  };

  // ------------------------------------------------------------------------------------------------------------------------
  // Advanced documentation for JSON.stringify, and the 'replacer' function argument:
  // <https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/JSON/stringify#The_replacer_parameter>
  // ------------------------------------------------------------------------------------------------------------------------
   
  
  const getSchemaReplacer = () => {
    const seen = new WeakSet();
    return (key, value) => {
      if ( key === 'sampleRows' ) {
        return undefined;
      } else if (key === 'foreignTable') {
        let ftobj = { "id" : value.id , "name" : value.name };
        return ftobj;
      } else if (typeof value === "object" && value !== null) {
        if (seen.has(value)) {
          return;
        }
        seen.add(value);
      }
      return value;
    };
  };

  let serializedSchema = JSON.stringify(window.application,getSchemaReplacer(),2);
  let schema = JSON.parse(serializedSchema);
  let info = `${schema.name} (${schema.id})`;

  copyToClipboard(serializedSchema);

  alert(`Copied to Clipboard:\nJSON for ${info}`);

  console.log(serializedSchema);
 }
 )();
diff --git a/02-bookmarklet.md b/02-bookmarklet.md
	(function () {
	//-------------------------------------------------------------------------------------------------------------------------
	// To use this script, go the the API page for your Airtable Base (something like https://airtable.com/<base_id>/api/docs).
	// Then, open the javascript console (F12) on Chrome. Then copy this script and paste it into the console (and hit Enter).
	// The schema serialized as JSON should now be in your clipboard.
	//
	// Alternatively, you can use the bookmarklet below.
	//-------------------------------------------------------------------------------------------------------------------------

	// ------------------------------------------------------------------------------------------------
	// copyToClipboard implementation via:
	// <https://gist.github.com/Chalarangelo/4ff1e8c0ec03d9294628efbae49216db/#file-copytoclipboard-js>
	// ------------------------------------------------------------------------------------------------

	const copyToClipboard = str => {
	const el = document.createElement('textarea'); // Create a <textarea> element
	el.value = str; // Set its value to the string that you want copied
	el.setAttribute('readonly', ''); // Make it readonly to be tamper-proof
	el.style.position = 'absolute';
	el.style.left = '-9999px'; // Move outside the screen to make it invisible
	document.body.appendChild(el); // Append the <textarea> element to the HTML document
	const selected =
	document.getSelection().rangeCount > 0 // Check if there is any content selected previously
	? document.getSelection().getRangeAt(0) // Store selection if found
	: false; // Mark as false to know no selection existed before
	el.select(); // Select the <textarea> content
	document.execCommand('copy'); // Copy - only works as a result of a user action (e.g. click events)
	document.body.removeChild(el); // Remove the <textarea> element
	if (selected) { // If a selection existed before copying
	document.getSelection().removeAllRanges(); // Unselect everything on the HTML document
	document.getSelection().addRange(selected); // Restore the original selection
	}
	};

	// ------------------------------------------------------------------------------------------------------------------------
	// Advanced documentation for JSON.stringify, and the 'replacer' function argument:
	// <https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/JSON/stringify#The_replacer_parameter>
	// ------------------------------------------------------------------------------------------------------------------------


	const getSchemaReplacer = () => {
	const seen = new WeakSet();
	return (key, value) => {
	if ( key === 'sampleRows' ) {
	return undefined;
	} else if (key === 'foreignTable') {
	let ftobj = { "id" : value.id , "name" : value.name };
	return ftobj;
	} else if (typeof value === "object" && value !== null) {
	if (seen.has(value)) {
	return;
	}
	seen.add(value);
	}
	return value;
	};
	};

	let serializedSchema = JSON.stringify(window.application,getSchemaReplacer(),2);
	let schema = JSON.parse(serializedSchema);
	let info = `${schema.name} (${schema.id})`;

	copyToClipboard(serializedSchema);

	alert(`Copied to Clipboard:\nJSON for ${info}`);

	console.log(serializedSchema);
	}
	)();