The JSON library’s dumps function takes a Python structure-in this case a nested dictionary-and turns it into a JSON string for POSTing. The identification code in the URL is specific to the database, and the authorization code that goes in the header is specific to the user. The docs are formed with examples that are specific to your database they include your fields and your records, not some made-up example that means nothing to you.Īirtable doesn’t provide a Python library, but it’s easy to use the API through the Requests and JSON libraries: python:ġ3: 'email': r = requests.post(airURL, headers=airHeaders, data=json.dumps(payload)) The API is easy to understand and has possibly the best documentation I’ve ever seen. ![]() To reduce the clutter, I have a filter that shows only the latest projects.Īnd I sort them by number in inverse order because the projects I’m most likely to be looking for are the most recent. Within the Number type, you can choose between integer and floating point, which can be quite handy. Airtable has a variety of other field types that can specialize these two generic types: When I first imported the data, all the fields were treated as either text or numbers. The other fields can be seen by scrolling to the right. It’s easy to search by tapping the magnifying glass, but I often find the information I want (who’s the client on Project X? what project did I just open for Client Y?) sitting right in front of me when I open the app. Now I have a nice looking view of the project information (well, it’s nice looking when I haven’t scrambled the fields for anonymity). ![]() It took basically no time to export the data from SQLite and import it into Airtable. I didn’t really want to put in the effort to make the output prettier, but I was resigning myself to get down to it when Airtable appeared in my Twitter feed. This worked, but it was a little clumsy and the results, while correct, were ugly. ![]() Then I imported it into a SQLite database and rewrote the scripts in Python using the sqlite3 library.Īs I found myself wanting to search the database on my phone and iPad, I moved the database file to iCloud Drive and wrote some scripts in Pythonista to do the searching. A small set of Perl scripts were used to add and extract information.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |