User Auth (WeWeb) + Airtable sync

Hello!
I am using WeWeb auth to create new users and also I created a table in airtable to keep all info there, since that will be my backend. So the User_id created by wowed I send it directly to airtable like this:

The problem is that I am getting this error message:

stack: “Error: Request failed with status code 422 at e.exports (https://editor-cdn.weweb.io/public/js/chunk-vendors.792b3bba.js:1:120680) at e.exports (https://editor-cdn.weweb.io/public/js/chunk-vendors.792b3bba.js:1:123139) at XMLHttpRequest.w (https://editor-cdn.weweb.io/public/js/chunk-vendors.792b3bba.js:1:115226)”

This is the set up of the workflow, where I capture name, email and user_id (from weweb auth):



Also, as you can see, there area 2 more field in the user database that I am capturing from now, since one is related to the payment process and the other one is related to another table.

Let me know what I’m doing wrong please. Thanks a lot!

Hi @rafa_flama :wave:

First of all, if you are building a web-app that will process payments with user roles & permissions, I’d highly recommend using a backend tool like Xano or Supabase because Airtable will be limited in terms of access controls and filtering. (If you’re interested in learning more on how to build a secure web-app with no-code tools, here’s a good intro video: Security 101)

Now for your actual question, the 422 error suggest Airtable doesn’t understand the request. A couple of things you make sure the user_id field is a text column in Airtable, not a number

If that doesn’t work, can you show us the error message you get in the workflow logs:

In the example above, I get:

  • error: “INVALID_VALUE_FOR_COLUMN”
  • message: “Field “id” cannot accept the provided value”

This tells me that I tried sending a value of a different data type (text) than what Airtable expected (a number)

Does that help?

Thanks @Joyce i will definitely think about changing to supabase. Cheers!