API - pass value from query to POST body

Question and Answers
1

Hello,
New to AppSmith. Newbie in general.

I’ve got a mysql datasource set up with a table. In a column, I’ve put a button.

For that button, I’ve set an OnClick to run a POST with an API.
The body of the API has a couple of values that I’d like to set from the row of the table. But I’m not sure how to do that.

Any advice or links to help/posts/docs appreciated.

2

I think I’m on the right track. I’m actually surprised how easy it is. I guess I was thinking it would be more difficult.

3

Hey :wave: I hope you were able to figure this out. In case you weren’t, you can bind the body of the API call to the table selected row as
{
“name”: {{ Input1.text }},
“gender”: {{ Select1.selectedOptionValue }},
}

This is a guide on capturing form data

4

Yes, I was able to get it working. I just wasn’t sure about the current vs. selected and a few other items to specify. I just kept trying various options. The contextual help, suggestions and live display really helps.