In fact it's kind of weird. The same payload fails via curl and success via postman (http client)
Here test data :
[["INSERT INTO Influencer(id,fb_id,full_name,link,phone,social_networks,hash_tags,verified,profile_verified,follower_last_count,followers_last_count_dt,business_category,profile_id,username,email,fullname,profile_picture,gender,birth_year,country,location,last_update,media_count,added_at) VALUES (:id,:fb_id,:full_name,:link,:phone,:social_networks,:hash_tags,:verified,:profile_verified,:follower_last_count,:followers_last_count_dt,:business_category,:profile_id,:username,:email,:fullname,:profile_picture,:gender,:birth_year,:country,:location,:last_update,:media_count,:added_at)",{"id":"21af00a7-c0f1-4361-89aa-f4aed9538da9","fb_id":"1695391035","full_name":"Alexandria Hoareau","link":"http:\/\/
www.mahe.fr\/aperiam-fugiat-eius-omnis-non-facilis-consectetur-sapiente-eos","phone":"
+33 (0)5 06 88 10 03","social_networks":"[\"tiktok\",\"mastodon\"]","hash_tags":"[\"#toto\",\"#tata\"]","verified":"false","profile_verified":"false","follower_last_count":0,"followers_last_count_dt":1641928321,"business_category":"dumont","profile_id":"2830622","username":"maurice.laine","email":"
isabell...@wanadoo.fr","fullname":"Alexandria Hoareau","profile_picture":"","gender":0,"birth_year":1971,"country":"Territoire britannique de l'oc\u00e9an Indien","location":"","last_update":"","media_count":"","added_at":1641928321}]]
This command fails :
curl -X POST "
http://10.0.4.20:4001/db/execute"-H "Content-Type: application/json" -d "[["INSERT INTO Influencer(id,fb_id,full_name,link,phone,social_networks,hash_tags,verified,profile_verified,follower_last_count,followers_last_count_dt,business_category,profile_id,username,email,fullname,profile_picture,gender,birth_year,country,location,last_update,media_count,added_at) VALUES (:id,:fb_id,:full_name,:link,:phone,:social_networks,:hash_tags,:verified,:profile_verified,:follower_last_count,:followers_last_count_dt,:business_category,:profile_id,:username,:email,:fullname,:profile_picture,:gender,:birth_year,:country,:location,:last_update,:media_count,:added_at)",{"id":"21af00a7-c0f1-4361-89aa-f4aed9538da9","fb_id":"1695391035","full_name":"Alexandria Hoareau","link":"http:\/\/
www.mahe.fr\/aperiam-fugiat-eius-omnis-non-facilis-consectetur-sapiente-eos","phone":"
+33 (0)5 06 88 10 03","social_networks":"[\"tiktok\",\"mastodon\"]","hash_tags":"[\"#toto\",\"#tata\"]","verified":"false","profile_verified":"false","follower_last_count":0,"followers_last_count_dt":1641928321,"business_category":"dumont","profile_id":"2830622","username":"maurice.laine","email":"
isabell...@wanadoo.fr","fullname":"Alexandria Hoareau","profile_picture":"","gender":0,"birth_year":1971,"country":"Territoire britannique de l'oc\u00e9an Indien","location":"","last_update":"","media_count":"","added_at":1641928321}]]"
But sent as http body it runs ok. Nevermind, i'll use http client :)
I spent some hours to figure out how to properly generate statements, it looked ok and then now it's ok with http client, when I quote properly and when i don't let the client itself do the json encoding.