Hi Everyone, I’m pleased to present Airtable.jl, a wrapper of the API for the julia programming language.
It’s a pretty simple little package, but it’s my first time working in any depth with a WebAPI, so I’m pretty pleased to have it working as well as it does. Currently, it has support for get, post, patch and delete methods, and a special function query that is basically get, but handles pagination in the response.
Please take a look at the docs, and feel free to open issues if you run into any problems!
Here’s an example of what you can do, using this dummy table:
julia> using Airtable
julia> cred = Airtable.Credential() # Pulls from environmental variable "AIRTABLE_KEY"
Airtable.Credential(<secrets>)
julia> abase = AirBase("appphImnhJO8AXmmo")
Airtable Base 'appphImnhJO8AXmmo'
julia> tab = AirTable("Table 1", abase)
AirTable("Table 1")
julia> records = Airtable.query(tab)
3-element Vector{AirRecord}:
AirRecord("recMc1HOSIxQPJyyc", AirTable("Table 1"), (Name = "Record 1", Notes = "Keep this\n", Status = "Todo", Keep = true, CI = "N/A"))
AirRecord("recMwT4P4tKlSLJoH", AirTable("Table 1"), (Name = "Record 2", Notes = "Also keep this", Status = "In progress", Keep = true, CI = "N/A"))
AirRecord("recSStgr3yJnQc2Wg", AirTable("Table 1"), (Name = "Record 3", Status = "Done", Keep = true, CI = "N/A"))
julia> Airtable.query(tab; filterByFormula="{Status}='Todo'")
1-element Vector{AirRecord}:
AirRecord("recMc1HOSIxQPJyyc", AirTable("Table 1"), (Name = "Record 1", Notes = "Keep this\n", Status = "Todo", Keep = true, CI = "N/A"))
julia> resp = Airtable.post!(tab, (; Name = "Some record", Status="Todo"))
AirRecord("recktAILkVMB7huKl", AirTable("Table 1"), (Name = "Some record", Status = "Todo"))
julia> Airtable.query(tab; filterByFormula="{Status}='Todo'")
2-element Vector{AirRecord}:
AirRecord("recMc1HOSIxQPJyyc", AirTable("Table 1"), (Name = "Record 1", Notes = "Keep this\n", Status = "Todo", Keep = true, CI = "N/A"))
AirRecord("recktAILkVMB7huKl", AirTable("Table 1"), (Name = "Some record", Status = "Todo"))
julia> Airtable.patch!(resp, (; Status = "In progress"))
AirRecord("recktAILkVMB7huKl", AirTable("Table 1"), (Name = "Some record", Status = "In progress"))
julia> Airtable.delete!(resp)
JSON3.Object{Base.CodeUnits{UInt8, String}, Vector{UInt64}} with 2 entries:
:deleted => true
:id => "recktAILkVMB7huKl"
