3e:null 3f:["$","title",null,{"children":"Airtable Base Schema Diff | Ross Mills | Observable"}] 45:T428,

${diff[0].map( (d, i) => html`

${d.lineNumber || ''} ${Array.from({ length: d.level }, () => ' ')} ${d.text} ${d.comma ? ',' : ''}

${diff[1][i].lineNumber || ''} ${Array.from({ length: diff[1][i].level }, () => ' ')} ${diff[1][i].text} ${diff[1][i].comma ? ',' : ''}

` )}

46:[] 43:{"id":"8d9379004a9d4c9e","slug":null,"title":"Airtable Base Schema Diff","thumbnail":"2752dd14865c59585de4a6c6e6a12a680be0b6172a9857b9e79c5e66d7e222a7","access_level":"public","create_time":"$D2024-02-14T10:33:44.825Z","update_time":"$D2024-04-30T21:47:12.349Z","view_time":null,"first_public_time":"$D2024-02-14T11:34:38.482Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"55e9268ccca383a5","login":"rossmills99","name":"Ross Mills","avatar_url":"https://avatars-next.observableusercontent.com/edf6d8f13cc81ae6ed5c2a7f7911f9b522006a0413d822217f3666daf05d1366","tier":"starter_2024","bio":"Software engineer and hands-on tech leader. Creating and collaborating on interesting software projects gets me out of bed in the morning.","following":false},"version":261,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"3d55deecec17df75","login":"rossmills99","name":"Ross Mills","avatar_url":"https://avatars-next.observableusercontent.com/edf6d8f13cc81ae6ed5c2a7f7911f9b522006a0413d822217f3666daf05d1366","tier":null,"bio":"Software engineer and hands-on tech leader.\n","following":false}],"members":[{"type":"individual","id":"3d55deecec17df75","login":"rossmills99","name":"Ross Mills","avatar_url":"https://avatars-next.observableusercontent.com/edf6d8f13cc81ae6ed5c2a7f7911f9b522006a0413d822217f3666daf05d1366","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Airtable Base Schema Diff","cells":[{"id":0,"value":"# Airtable Base Schema Diff\n\nCompare the JSON schema of two Airtable bases.\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":5,"value":"viewof pat = Inputs.password({\n label: \"Personal Access Token\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":8,"value":"viewof baseSource = Inputs.text({ label: \"Source Base ID\" })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":138,"value":"viewof baseDest = Inputs.text({ label: \"Destination Base ID\" })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":150,"value":"viewof goButton = Inputs.button(\"Go\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":12,"value":"## Schema Diff","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":205,"value":"viewof options = Inputs.checkbox([\n \"Sort fields before diff\",\n \"Remove IDs before diff\"\n])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":165,"value":"$45","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":130,"value":"---\n## Appendix","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":14,"value":"tables = {\n goButton;\n\n if (!baseSource || !baseDest || !pat) {\n return helpMessage;\n }\n\n const headers = {\n Authorization: \"Bearer \" + pat\n };\n\n let source = await fetch(\n `https://api.airtable.com/v0/meta/bases/${baseSource}/tables`,\n {\n headers\n }\n ).then((response) => response.json());\n\n let dest = await fetch(\n `https://api.airtable.com/v0/meta/bases/${baseDest}/tables`,\n {\n headers\n }\n ).then((response) => response.json());\n\n source = prepareSchema(source);\n dest = prepareSchema(dest);\n\n return { source, dest };\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":162,"value":"diff = {\n const differ = new jsonDiffKit.Differ({});\n return differ.diff(tables.source, tables.dest);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":20,"value":"Airtable = require(\"airtable@0.12.2/lib/airtable.umd.js\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":90,"value":"helpMessage = \"Enter Base ID and PAT token\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":229,"value":"function prepareSchema(schema) {\n if (options.includes(\"Sort fields before diff\")) {\n schema = sortFields(schema);\n }\n if (options.includes(\"Remove IDs before diff\")) {\n schema = removeIds(schema);\n }\n return schema;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":240,"value":"function removeIds(schema) {\n schema.tables.forEach((table) => {\n delete table.id;\n table.fields.forEach((field) => {\n delete field.id;\n });\n table.views.forEach((view) => {\n delete view.id;\n });\n });\n return schema;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":209,"value":"function sortFields(schema) {\n const byName = (a, b) => (a.name === b.name ? 0 : a.name > b.name ? 1 : -1);\n schema.tables.sort(byName);\n schema.tables.forEach((table) => {\n table.fields.sort(byName);\n table.views.sort(byName);\n });\n return schema;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":146,"value":"jsonDiffKit = import(\"https://cdn.skypack.dev/json-diff-kit@1.0.23?min\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W46","stdlib":"1"}} 44:"$43:body"