2b:null 2c:["$","title",null,{"children":"Personalization API & Movement SDK Chains | FSQ Docs | Observable"}] 31:T1333,table = async function*(dataPromise, options = {}) { yield loader; const dataO = await Promise.resolve(dataPromise); let filter = () => true; const data = Array.isArray(dataO) ? dataO : Object.entries(dataO).map(([key, v]) => Object.assign({ key }, v)); let { humanize, nully, limit, columns, enableFilter, enableCSVDownload, maxHeight } = Object.assign( { humanize: defaultHumanize, nully: () => '-', columns: Object.keys(data[0]), enableFilter: data.length > 50, enableCSVDownload: true, maxHeight: 400 }, options || {} ); if (typeof maxHeight === 'number') maxHeight = `${maxHeight}px`; columns = columns.map(column => { let key; if (typeof column == 'string') { key = column; column = { key }; } else { key = column.key; } const decimalNumber = data.reduce((memo, d) => { if (typeof d[key] === 'number') { let frac = (d[key] || '').toString().split('.')[1]; if (frac) return Math.max(memo, frac.length); } return memo; }, 0); return Object.assign( { name: humanize(key), type: typeof data[0][key], accessor: row => row[key], render: val => { if (decimalNumber && typeof val === 'number') { return val.toFixed(decimalNumber); } if (val == null || val == undefined) { return nully(val); } return val; } }, column ); }); const renderTable = () => { return `${data .filter(filter) .slice(0, limit) .map( datum => ` ${columns .map(c => { return `${c.render(c.accessor(datum))}`; }) .join('')} ` ) .join('')}`; }; const output = html`

${columns .map( c => `` ) .join('')} ${renderTable()}

${c.name}

${ data.filter(filter).length > limit ? `

This table has been truncated from ${data.length} rows to ${limit}

` : '' }

${ enableFilter ? '

🔎

' : '' }

`; output.value = dataO; yield output; output.querySelectorAll('th').forEach(th => th.addEventListener('click', () => { const key = th.dataset.key; const order = th.dataset.order === 'ascending' ? -1 : 1; data.sort((a, b) => a[key] > b[key] ? order : b[key] > a[key] ? -order : 0 ); output.querySelector('tbody').innerHTML = renderTable(); th.dataset.order = order === -1 ? 'descending' : 'ascending'; }) ); if (enableFilter) { const search = output.querySelector('input[type=search]'); search.addEventListener('input', e => { filter = parseQuery(search.value, columns); output.querySelector('tbody').innerHTML = renderTable(); }); } if (enableCSVDownload) { output.appendChild( DOM.download( new Blob( [ CSV(data, { fields: columns.map(c => ({ label: c.name, value: c.key })) }) ], { type: "application/json" } ), 'places-api-and-flat-file-chains.csv', '⬇' ) ); } }32:T745,loader = html` Loading...`33:[{"id":"95ea043269feb7085db223e4111cf91d1b3c91d0a042eb129976a1c3cc7e8b41bc3d9ddc24e370429973cc8d375fb8d159e4dfe56929098d7a9a235a2d4a93e8","href":"https://static.observableusercontent.com/files/95ea043269feb7085db223e4111cf91d1b3c91d0a042eb129976a1c3cc7e8b41bc3d9ddc24e370429973cc8d375fb8d159e4dfe56929098d7a9a235a2d4a93e8","name":"export (10).csv","type":"text/csv","lastModified":1715811284806.957,"size":203475},{"id":"a6b9d5d54693043921464bd84a19e0b32fb693f97527a5c428dfa3f403b0293eda667147a08dc506d46fbb32ed7745d0d65cca9d86e28092ca5b28aafb3931e3","href":"https://static.observableusercontent.com/files/a6b9d5d54693043921464bd84a19e0b32fb693f97527a5c428dfa3f403b0293eda667147a08dc506d46fbb32ed7745d0d65cca9d86e28092ca5b28aafb3931e3","name":"export (11).csv","type":"text/csv","lastModified":1720026068934.258,"size":207261},{"id":"1b583eb7df186d64a14aeb01adeab221704fab05d37044d333cc3d3829c74808fbf29a6aa63d60211891a7f01472fae96d75ec4e33146cfdd9dc7cf2c21d1ac9","href":"https://static.observableusercontent.com/files/1b583eb7df186d64a14aeb01adeab221704fab05d37044d333cc3d3829c74808fbf29a6aa63d60211891a7f01472fae96d75ec4e33146cfdd9dc7cf2c21d1ac9","name":"legacy-05-13.numbers","type":"application/zip","lastModified":1715633396589.696,"size":1210557},{"id":"1b583eb7df186d64a14aeb01adeab221704fab05d37044d333cc3d3829c74808fbf29a6aa63d60211891a7f01472fae96d75ec4e33146cfdd9dc7cf2c21d1ac9","href":"https://static.observableusercontent.com/files/1b583eb7df186d64a14aeb01adeab221704fab05d37044d333cc3d3829c74808fbf29a6aa63d60211891a7f01472fae96d75ec4e33146cfdd9dc7cf2c21d1ac9","name":"legacy-05-13@1.numbers","type":"application/zip","lastModified":1715633478315.267,"size":1210557},{"id":"d751670aabe089749b884f861e1cefc21c5f804825d8e2c833436be1cef1f0fce6e1bcd622d8116245cfda955baf09a7dc404f8209e1aed4fb14fb2f0386aa97","href":"https://static.observableusercontent.com/files/d751670aabe089749b884f861e1cefc21c5f804825d8e2c833436be1cef1f0fce6e1bcd622d8116245cfda955baf09a7dc404f8209e1aed4fb14fb2f0386aa97","name":"legacy-05-13.csv","type":"text/csv","lastModified":1715633593367.237,"size":159765},{"id":"d751670aabe089749b884f861e1cefc21c5f804825d8e2c833436be1cef1f0fce6e1bcd622d8116245cfda955baf09a7dc404f8209e1aed4fb14fb2f0386aa97","href":"https://static.observableusercontent.com/files/d751670aabe089749b884f861e1cefc21c5f804825d8e2c833436be1cef1f0fce6e1bcd622d8116245cfda955baf09a7dc404f8209e1aed4fb14fb2f0386aa97","name":"legacy-05-13@1.csv","type":"text/csv","lastModified":1715633684941.539,"size":159765},{"id":"62a6565c70d69c811617455c7ccd7f8d92e72d1028a4d730fcfd28b8030959d3671e3a51b0a7e10f4f58919311884e049578e4d0f66574433c7dfb8d870bf561","href":"https://static.observableusercontent.com/files/62a6565c70d69c811617455c7ccd7f8d92e72d1028a4d730fcfd28b8030959d3671e3a51b0a7e10f4f58919311884e049578e4d0f66574433c7dfb8d870bf561","name":"export (7).csv","type":"text/csv","lastModified":1715633850548.853,"size":155845},{"id":"9f0f78636ecfa74b34394a86bbf947d528c748a49d846303daae11c4dcf20806c04017bb22702dd46c916b95a210903a29537814ca56b53ee965e97912d26da6","href":"https://static.observableusercontent.com/files/9f0f78636ecfa74b34394a86bbf947d528c748a49d846303daae11c4dcf20806c04017bb22702dd46c916b95a210903a29537814ca56b53ee965e97912d26da6","name":"export (5).csv","type":"text/csv","lastModified":1707409144571.316,"size":200382},{"id":"275684fb4b437dc510a32d961b949532a9e89afbaeff69efce34568ed4dfd4277fadeec4afa6b173571b9cccf85647df67eeb318a72674903fe387e79c3c4bd9","href":"https://static.observableusercontent.com/files/275684fb4b437dc510a32d961b949532a9e89afbaeff69efce34568ed4dfd4277fadeec4afa6b173571b9cccf85647df67eeb318a72674903fe387e79c3c4bd9","name":"export (6).csv","type":"text/csv","lastModified":1707409187182.578,"size":154053}] 2f:{"id":"61d77a847585bd20","slug":null,"title":"Personalization API & Movement SDK Chains","thumbnail":"49e3b8e7b5c25c76853ac31b4ed41e895e2facb91573182f4e68e995d0ccb899","access_level":"public","create_time":"$D2024-02-08T16:19:04.571Z","update_time":"$D2024-07-03T17:01:44.497Z","view_time":null,"first_public_time":"$D2024-02-08T16:19:04.571Z","has_unpublished_edits":null,"fork":{"id":"816c79a4e4c495b8","slug":null,"title":"Places API & Flat File Chains","owner":{"id":"5063adf704c7df7a","login":"fsq-docs","name":"FSQ Docs"}},"stars":0,"starred":false,"owner":{"type":"team","id":"5063adf704c7df7a","login":"fsq-docs","name":"FSQ Docs","avatar_url":"https://avatars-next.observableusercontent.com/9f54d1474fb58dabe51cc5e9e0eed340276d81a3772552943fc6d989617c9384","tier":"starter_2024"},"version":344,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"8e28be01ac382f14","login":"gfletcher","name":"Foursquare","avatar_url":"https://avatars-next.observableusercontent.com/4cbeb76acfd30c680315bc1b4f52cdb3dafe35813d74a6e0292ca70a1df32573","tier":null}],"members":[{"type":"team","id":"5063adf704c7df7a","login":"fsq-docs","name":"FSQ Docs","avatar_url":"https://avatars-next.observableusercontent.com/9f54d1474fb58dabe51cc5e9e0eed340276d81a3772552943fc6d989617c9384","tier":"starter_2024","role":"editor"},{"type":"individual","id":"8e28be01ac382f14","login":"gfletcher","name":"Foursquare","avatar_url":"https://avatars-next.observableusercontent.com/4cbeb76acfd30c680315bc1b4f52cdb3dafe35813d74a6e0292ca70a1df32573","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"title":"Personalization API & Movement SDK Chains","cells":[{"id":256,"value":"# Personalization API & Movement SDK Chains","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":237,"value":"categories = FileAttachment(\"export (11).csv\").csv({typed: true})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":340,"value":"export11 = await FileAttachment(\"export (11).csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"export11","database":"$undefined"},{"id":78,"value":"viewof data = table(categories,\n{ \n columns: [\n { \n key: 'chain_id',\n name: 'Chain ID',\n }, \n {\n key: 'chain_name', \n name: 'Chain Name'\n }]\n }\n )","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":107,"value":"parseQuery = (q, headers) => {\n if (q == '') {\n return () => true;\n } else if (q.match(/[=<>]/)) {\n try {\n const code = headers.reduce((q, {key, name}) => q.replace(new RegExp(`\\\\b(${key}|${name})\\\\b`, 'g'), `data['${key}']`), q).replace(/([^=<>!])=([^=<>!]|$)/g, '$1===$2');\n return new Function('data', `try { return ${code} } catch(e) { return false; }` );\n } catch (e) {\n return () => true;\n }\n } else {\n const re = new RegExp(q, 'i');\n \treturn data => headers.some(({key}) => (data[key] || '').toString().match(re))\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":58,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":7,"value":"defaultHumanize = str => str.replace(/[-_]/g, ' ')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":176,"value":"CSV = require('json2csv@4.0.0').then(a => a.parse)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W33","stdlib":"1","titling":"auto"}} 30:"$2f:body"