Anyone have success with startingNumber attribute for POST or PUT autoNumberFormat object requests?

coby · 10/03/21

I am trying to modify an a column to an AUTO_NUMBER systemColumnType. The API does NOT return an error, but rather the 'startingNumber' attribute does not actually have an effect on the sheet. I have tried both via the python sdk and also via CUrl command, I'm stumped. Anyone have any luck with this before?

PYTHON

#Column Update

column_spec = smart.models.Column({

'type':'TEXT_NUMBER',

'systemColumnType': 'AUTO_NUMBER',

'autoNumberFormat': {'startingNumber':50, 'fill':'000000'}

})

# Update column

response = smart.Sheets.update_column(

{SHEET-ID}, # sheet_id

{COLUMN-ID}, # column_id

column_spec)

CURL COMMAND

curl https://api.smartsheet.com/2.0/sheets/{SHEET-ID}/columns/{COLUMN-ID} ^

-H "Authorization: {ACCESS TOKEN}" ^

-H "Content-Type: application/json" ^

-X PUT ^

-d "{\"index\":\"0\",\"title\":\"ROW-ID\",\"type\":\"TEXT_NUMBER\",\"systemColumnType\": \"AUTO_NUMBER\",\"autoNumberFormat\": {\"startingNumber\":\"50\", \"fill\":\"000000\"}}"

Etienne Mermillod · 10/04/21

Hi,

I just tested with the c# wrapper and it seems to be working :

            SheetFetchedStore.Client.ssclient.SheetResources.ColumnResources.UpdateColumn(8767142637135748,
               new Smartsheet.Api.Models.Column
               {
                   Id = 4810157732456324,
                   Title = "tesjthh",
                   Index = 0,
                   Type = Smartsheet.Api.Models.ColumnType.TEXT_NUMBER,
                   SystemColumnType = Smartsheet.Api.Models.SystemColumnType.AUTO_NUMBER,
                   AutoNumberFormat = new Smartsheet.Api.Models.AutoNumberFormat
                   {
                       Fill = "",
                       Prefix = "pfx",
                       StartingNumber = 200,
                       Suffix = "sfx"
                   }
               });

Body sent :

{"fill":"","prefix":"pfx","startingNumber":200,"suffix":"sfx"},"index":0,"title":"tesjthh"}

Maybe try by specifing all properties (fill, prefix, starting and suffix) ?

Anyone have success with startingNumber attribute for POST or PUT autoNumberFormat object requests?

Answers

Categories