On insert I get this error -> "All object keys must match". I tried to set the autogenerated keys also but no luck. Any idea?

Hello @theuknowner! This thread has been automatically created from your message in #843999948717555735 a ``few seconds ago``. Pinging @User so that they see this as well! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ... menu) and select Leave Thread to unsubscribe from future updates. Want to change the title? Use the

/title

command! We have solved your problem? Click the button below to archive it.

Can you provide example code of what you are trying please? otherwise its hard to assist you with the issue you are having.

theuknowner (2022-03-31)

@User Sure, I use the sample code that you have in Supabase-swift

Are you using supabase-swift or postgres-swift for your overall environment. The code example you have is from the postgres-swift only example which is different setup than the supabase-swift one as far as the example object structure...

I tried with both packages

@User can you share more of your code like where you instantiated the supabase client

struct Todo: Codable { var test: String var `id`: Int? var testNum: Int } let postgrClient = PostgrestClient( url: "xxxxxxxxxxx", headers: ["authorization": "Bearer xxxxxxxxxxxx" , "apikey": "xxxxxxxxx"], schema: "public") do { let todo = Todo(task: "fix some issues in postgrest-swift", testNum: 12) let jsonData: Data = try JSONEncoder().encode(todo) postgrClient.from("todo").insert(values: jsonData).execute { (result) in switch result { case .success(let response): guard let data = response.body as? Data else { return } do { let todos = try JSONDecoder().decode([Todo].self, from: data) print(todos) } catch { print(error.localizedDescription) } case .failure(let error): print(error.localizedDescription) } } }catch { print(error.localizedDescription) }

You have test in your structure by use task in your todo set up

What I have tried so far: 1) If I set it to [String:String] it's ok BUT only if my Codable Item has String values

let todo = Todo(task:

Do you mean to assign it to a variable? I don't understand

struct Todo: Codable { var test: String var id: Int? var testNum: Int } So when your: let todo = Todo(task: "fix some issues in postgrest-swift", testNum: 12) Needs test: not task:

Yes task, I copy pasted wrong Struct

OK but your code you showed had test as the name in the structure. You might also have an uppercase problem with your table. Was it defined "testNum" with quotes. Just passing in column testNum may get coverted to lowercase. You really should avoid camelCase in postgres tables if possible. But I'm not sure you error is hitting that yet.

I'm not a Swift dev but from our example code you need to use a JSON dictionary, I'm not sure what JSONEncoder().encode does, but the example on the supabase-swift repo uses JSONSerialization.jsonObject along with the encoder https://github.com/supabase-community/supabase-swift#database

@User Yes I know about the camel case in postgres, but in JS - Kotlin I don;t have any issue with this

I am going to bow out as it could be swift specific and I've gone thru the easy stuff. You might ask in that repository, or in the swift section below. Unless @User has more ideas..

Ah found it I think

I use the postgrest-swift package. So it's client.from

You should not be using that package directly

The Supabase-Swift needs the ".database.from" because the package is bundled

@User In Swift thread, You just posted the same code with test in your object structure, but task in your todo setup. I thought you said the object structure was wrong...

I changed it, thanks