Hey awesome community people @enlightened, @pepperaddict and @supernova!
Thanks for staying on this case and making sure we can figure this out together! I really appreciate your continued support and - your contributions to the community have been just top-notch lately. Honestly, thank you for taking the time out of your day to help other users out
I’ve taken a further look at this with the team, and we have come to the conclusion that the values you are trying to send to our servers are not formatted as JSON correctly, which is why they’re getting blocked with an error:
To me, it seems like you are applying the JSON.stringify in a way that shouldn’t work with our API, especially seeing as some columns, like the Text column, have a different structure to their data than others.
This is what I am referring to when saying the JSON.stringify code could be used in a better way:
variables: JSON.stringify({“value”: “SAMPLE”})
Instead, it should be
variables: JSON.stringify({“value” : JSON.stringify(“SAMPLE”)})
Overall, the isn’t going through as expected because at this point in time, our column value parser expects JSON values (not primitives) in most cases, which is something that @supernova is referring to in his post as well. This means that even if the value you are sending is a string of text to a Text column, the whole string has to be formatted as JSON for the platform to recognise it as such. Does that make sense?
That said, I do think this is a point of friction and tension for a lot of our users, as I have issues with this exact process myself. To be transparent with you, we are already working on making further improvements to this area and I want to make sure this thread is not lost in the community - I’ve passed it on to the development team just to show how big of an impact this current setup has on our users.
@supernova
I really appreciate you coming forth with a list of suggestions that would make our users’ life with code easier, as creating apps and integrations is not an easy task to begin with. I’m stunned by the time you’ve put into making sure your experience is taken into account and I definitely agree that the documentation needs some love from our team to make it clearer, easier to use and more intuitive.
I’m afraid I can’t commit to an ETA when the changes you are looking for would become more than suggestions and be implemented in practice, but I’ve taken those points to the team and hopefully, we can make an effort together to make this part of the platform better. Again, I appreciate your awesome, friendly and clear input with action steps, as this helps us make those changes in a quicker way as well.
-Alex