Greetings
I am working on a pack with a sync table from an API.
I believe with the help of the excellent Coda documentation I have achieved the hardest part and can retrieve the data I am seeking, as I can display response.body as a console.log message in Pack Maker tools as below:
The problem is that the data does not get assigned to columns in my table with a simple “return response.body.” I cannot even log individual fields.
I believe this is a complex JSON object correct? Let’s suppose I want to retrieve the field title. If I write to log response.body.title it says ‘undefined.’
I know I need to write a function for each column. How do I write a function for example that takes each response.body.title and response.body.abstractText and places those in the corresponding columns in my new table?
[ { key: 'S9BTJNAD', version: 20563, library: { type: 'user', id: 571747, name: 'rkaplan@umrpc.com', links: [Object] }, links: { self: [Object], alternate: [Object], up: [Object] }, meta: {}, data: { key: 'S9BTJNAD', version: 20563, parentItem: 'KVNKCAXQ', itemType: 'attachment', linkMode: 'linked_url', title: 'PubMed entry', accessDate: '2022-04-14T17:09:18Z', url: 'http://www.ncbi.nlm.nih.gov/pubmed/32702693', note: '', contentType: 'text/html', charset: '', tags: [], relations: {}, dateAdded: '2022-04-14T17:09:18Z', dateModified: '2022-04-14T17:09:18Z' } }, { key: 'KVNKCAXQ', version: 20563, library: { type: 'user', id: 571747, name: 'rkaplan@umrpc.com', links: [Object] }, links: { self: [Object], alternate: [Object] }, meta: { creatorSummary: 'Vajramani', parsedDate: '2020', numChildren: 1 }, data: { key: 'KVNKCAXQ', version: 20563, itemType: 'journalArticle', title: 'Percutaneous Electrical Nerve Stimulation for Facial Pain', creators: [Object], abstractNote: 'Percutaneous electrical nerve stimulation (PENS) is a novel, minimally invasive