微盘智能表格添加数据,调用成功,文本可以添加,但数字和日期没有添加进去?官方大佬麻烦帮忙看一下?
提问
这个是地址:https://qyapi.weixin.qq.com/cgi-bin/wedoc/smartsheet/add_records?access_token
这是传过去的参数:{"key_type":"CELL_VALUE_KEY_TYPE_FIELD_ID","sheet_id":"q979lj","records":[{"values":{"f53B4X":[{"text":1730273586795,"type":"string"}],"fn0JxU":[{"text":"11111111","type":"double"}],"fzSueb":[{"text":"阿国讲餐饮","type":"text"}]}}],"docid":"dcb_8bpWq7J9C5vXvGUXGEhPzrKFoRDt1jZKYCIb2143D-T0JWRtZDHLiXHQuYIP89MbtPXQlh8mDWlfRTZP9kVA"}
这是返回的结果:{errcode=0, records=[{record_id=rHrQqO, values={f53B4X=[{text=1730273586795, type=string}], fn0JxU=[{text=11111111, type=double}], fzSueb=[{text=阿国讲餐饮, type=text}]}}], errmsg=ok},
您好,FILED_TITLE是传入字段值。这里传的参数也不对。添加记录可以看成是一行的记录,根据行来添加。
"docid": "DOCID",
"sheet_id": "123Abc",
"key_type": "CELL_VALUE_KEY_TYPE_FIELD_TITLE",
"records": [{
"values": {
"日期":"1730256354000"
}
}]
}
"docid": "DOCID",
"sheet_id": "123Abc",
"key_type": "CELL_VALUE_KEY_TYPE_FIELD_TITLE",
"records": [{
"values": {
"数字": "123"
}
}]
}
{"key_type":"CELL_VALUE_KEY_TYPE_FIELD_ID","sheet_id":"q979lj","records":[{"values":{"f53B4X":[{"text":"1730276850201","type":"string"}],"fn0JxU":[{"text":11111.0,"type":"double"}],"fzSueb":[{"text":"阿国讲餐饮","type":"text"}]}}],"docid":"dcb_8bpWq7J9C5vXvGUXGEhPzrKFoRDt1jZKYCIb2143D-T0JWRtZDHLiXHQuYIP89MbtPXQlh8mDWlfRTZP9kVA"}
用这种传参方式也不行