I am using the Smartsheet API token to access a brand new DataTable.
This is the batch file code which perfectly returns all IDs of the cells:
curl -X GET -H "Authorization: Bearer %API_TOKEN%" "%BASE_URL%/datatables/%DATATABLE_ID%" ^
-H "Content-Type: application/json" ^
-o %OUT_FILE%
The batch file variables obviously work.
Then I try to post to add a row:
curl "%BASE_URL%/datatables/%DATATABLE_ID%/rows" ^
-H "Authorization: Bearer %API_TOKEN%" ^
-H "Content-Type: application/json" ^
-d @%IN_FILE% ^
-o %OUT_FILE%
The IN_FILE data:
[{"toTop":true, "cells": [
{"columnId": "7590725555121439", "value": "Corbin"},
{"columnId": "6341270152180469", "value": "12/25/2025"},
{"columnId": "4168020956269190", "value": "10:00 AM"},
{"columnId": "3294620137632526", "value": "45587"},
{"columnId": "4211100128157131", "value": "36"},
{"columnId": "3332082719961794", "value": "Draft"},
{"columnId": "4352907788296860", "value": "2435-1002, 2435-1003"},
{"columnId": "6223120708308615", "value": "4000, 2002"}
]}]
I always get in the OUT_FILE: {"message":"Missing Authentication Token"}
Any help would be appreciated, thanks.