Smartsheet API Error code 1012 and Status code:400

Himangi

Hello Team,

We are getting this Error code 1012 and Status code:400 (Bad data request )when we try to Add rows/Post data in the smartsheet using Smartsheet API. 

We have index 0 as Unique ID of Text/Number data type and it holds values. I have tried to clear all cookies and caches from web browser, and verified the URL before hitting the API to add rows, but still we are getting below error.

Also, we are using same access token for “Post method” that we use with “GET Method” to fetch data which absolutely works fine but we get error below only when we try to Add rows/Post data in the smartsheet

Please help us by providing some insights and steps we could follow to resolve this error.

{

 "errorCode" : 1012,

 "message" : "Required object attribute(s) are missing from your request: cell.columnId.",

 "refId" : "1k08ja0q4z1x6",

 "detail" : {

  "index" : 0

 }

}

 

Thanks,

Himangi

Genevieve P.

Hi @Himangi

Error Code 1012 indicates that "a required object attribute is missing from your request" (see the error code list in the API Documentation, here).

In your instance, the object cell.columnId is missing. Can you check to see in your code if there is a columnId listed as null instead of a value?

Here's another Community Post that had a similar error. If this hasn't helped, you may want to reach out in the Stack Overflow Community (see here), or communicate with Smartsheet Support so you can share your full code in a private channel.

Cheers!

Genevieve

Himangi

Thank you Genevieve :)

It was null in ColumnId and error is resolved now.

Genevieve P.

No problem! I'm glad you sorted it out. 🙂