Add sync script to pull submissions from Airtable - Githubissues

ipfs / ecosystem-directory

Interactive showcase of projects and products built using IPFS, the InterPlanetary File System.

https://ecosystem.ipfs.tech

15 stars 8 forks source link

Add sync script to pull submissions from Airtable #245

Closed 2color closed 2 years ago

2color commented 2 years ago

Background

This is a first go at implementing the discussed solution from https://github.com/ipfs/ecosystem-directory/issues/241.

Current state

Script pulls all records from the submissions-to-be-published view (which filters only records with "Included in directory" checked)
takes the json field, parses and stringifies (to ensure JSON is valid)

Bugs and JSON discrepancies (between projects in the repo and airtable)

If one of the user input fields contains " the JSON generated by the automation is broken, e.g. Nebulus
The sortNumbers field is an array of objects in the automation script and generated JSON while being an object in this repo's project
```
// in the repo
"sortNumbers": {
"since": 2017
},
// in airtable json
"sortNumbers": [
{
  "since": 2017
}
```

2color commented 2 years ago

Closing in favour of #249