Softr Database Returns Unrecognized field in request payload

Ask the community
1

Hi there, i have been trying to search records using softr’s database api and it always returns “Unrecognized field in request payload“ even if the field id is correct.

I tried getting all the contents without specifying the field id and i was successful in doing so but only on the documentation playground.

this payload returns the same message when i try to do it on make or n8n while it returns all the contents when i try to do it in the documentation playground

{
“filter”: {
“operator”: “AND”,
“leftSide”: “”,
“rightSide”: “”,
“lowerBound”: “”,
“upperBound”: “”,
“conditions”: “”
},
“sort”: {},
“paging”: {
“offset”: 0,
“limit”: 10
}
}

this is the error message i received on n8n
400 - “{\“message\”:\“Invalid payload\”,\“errorCode\”:\“UNKNOWN_FIELD\”,\“details\”:{\“operator\”:\“Unrecognized field in request payload\”}}”

I even tried the solution mentioned in this post but it still breaks when i try to add the paging info to the request body.

there is not enough information or example on the documentation page on how to manipulate the fields object in JSOn body.

Also one more thing i noticed is that the post endpoint for searching records is creating new records and filling the lookup field of the related record which i am using to search the table

2

My understanding is that there’s a problem when sending empty strings for fields that should either have values or be omitted entirely (although this isn’t a problem in playground, as you say)

For n8n:
• Use the HTTP Request node
• Set the body to JSON format
• Only add the fields you need - leave others unset rather than empty.

3

I tried this things you mentioned also checked the method to match the one mentioned in the doc but surprisingly it still returns “Unrecognized field“. I tried multiple combinations of the json without paging without sort even without fields and tried bypassing the field name with ““.

4

That’s frustrating. Hopefully someone else can help to solve this one, I don’t know what else to try that you haven’t already done.

5

Oh, I just found out Softr updated their database API and the documentation quite a bit :+1:

Can you share an actual request that you are sending to the API? That might help solve your issue.

6

I will update our documentation today… I think filtering section is outdated…

7

Done documentation updated

8

Thank you it works perfectly

1 Like