[API CURL DO] How to use these curl parameters in API component

[updates]

Hello and wlecome back from the holidays to everybody.

I would switch the sql_require_primary_key parameter to false to have no problems on creating Multi Reference table using Managed MySQL in Do.

To switch the said parameter to false, DO gives the following curl:

curl -X PATCH
-H “Content-Type: application/json”
-H “Authorization: Bearer $DIGITALOCEAN_TOKEN”
-d ‘{“config”: {“sql_mode”: ,“sql_require_primary_key”: false}}’
“https://api.digitalocean.com/v2/databases/XXXXXX/config”

Question is: how can I do this on the API component in Wappler ?
Or any other suggestion how to use this Curl ?

thank you very much

Roberto

[George]

See:

API Connector components, how to use and connect REST/Curl API's

With the API Connector in Wappler, you have gained a lot of power to directly connect to API’s and fetch data or call their actions. The API Connector is based on three components: API Data Source API Action API Form In this article you will learn when to use the different API components and how. API Data Source The API Data Source is the most simple component but powerful API component and gives you a way to fetch data from the API so you can use it on your page as dynamic data. A basic u…

[updates]

Thank you @George I already seen this one.
My question is concerning the -d line :

-d ‘{“config”: {“sql_mode”: ,“sql_require_primary_key”: false}}’

I suppose need o use the Input Data but what I must write in the name and in the value? Being encapsulated like that cannot understand how to do.

[Apple]

Read starting from here:

Is there a deep dive on apis?

1 - Tick Output checkbox 2 - Untick Pass Errors (optional, but I don’t like the behaviour of this checkbox) 3 - Remove the Headers except the api-key header (Wappler applies application/json automatically) Confirm if you’re doing something like this, to dynamically inject variables: [Screenshot] If you’re unable to get it to work, use a service like Beeceptor to get a mock URL you can POST to, to see what Wappler is actually sending

[updates]

Thank you very much:

so to change the sql_require_primary_key in Digital Ocean (to allow multi reference table without id) steps are the following:

1. Create Api Action in Server Connect with following details:

I just published for dummies like me

thank you very much! It worked