Looking for put API call with select options passed

[balaji-ranga]

curl -k --include --request PUT --header "Content-Type: text/csv" --data-binary @./Downloads/testt.csv 'https://hostname/_/sittest'

Above command helps me initalize the sheet and i need to set a value in the sheet as select box. I tried sending CSV like below s.no,Gender 1,"=Select('male','male,female')" or s.no,Gender 1,"Select('male','male,female')" Nothing works. Can you please help me with any option

[eddyparkinson]

Use the API - https://ethercalc.docs.apiary.io/

curl -H "Content-Type: application/json" -X POST -d '{"command":["set C2 formula textbox(\"fred@gmail\")"]}' http://host/_/sheetname

you can't add formulas via csv

you can do more than one "set" per curl. it is a list

-- I will close this, but let me know if you need more help

[balaji-ranga]

Thanks a lot @eddyparkinson