I'm trying to create a custom rest. Followed the instructions but nothing happens. I go through the process outlined in the docs I add query parameters okay, but where it says "switch to path parameters and click on parse" the button isn't active. I switch to SQL and add my query then click "map" but nothing happens. Testing just results in a server error. Are there some better tutorials for this or is it too new?
Thanks
this is what I get back:
{
"code": "MS009",
"message": "Incorrect server configuration",
"status": "INTERNAL_SERVER_ERROR"
}
All the other services created by default work fine with the same database
Although the find service doesn't work the same way as the video explains it should.
Appery.io is so frustrating!
I experienced this as well, but I don't think that Path or Map apply to the way that we're using API Express (and maybe don't work yet, I don't know about that part).
The solution to server errors for me was to figure out the proper way to format the SQL statement. The same exact error you got, incidentally.
I'm still working on this for string comparisons, but I got it working for numeric.
If your parameter is called somenumber then type it as 'somenumber' in your SQL statement.
Thanks Jason. Yep, went back to what i know, SQL, and it work. Possibly thinking too much on this. Now I just got to figure how to present a list of data in a nice format and I'm away with the mixer:)