Data Shuttle - Out of Range Exception
Hi,
I keep getting this exception when importing data from my excel sheet to Smartsheet using data shuttle (aka data uploader).
Add rows to target sheet: "Unable to parse request. The following error occurred: Field \"value\" was not parsable. Numeric value (21081100066000000000) out of range of long (-9223372036854775808 - 9223372036854775807)\n at [Source: java.io.PushbackInputStream@717f9870; line: 1, column: 15215]."
It seems that some of my numbers are too long (this is one of my numbers 21081100066000000000). Is there any workaround for this. I really want to use data shuttle to get my data into Smartsheet.
Thanks
Best Answer
-
Hi @ygoldgrab
This is a current limitation of the Smartsheet API; to pass a number through the API, it must be larger than -9223372036854775808 and smaller than 9223372036854775807. Please let the Product team know about your use-case and feedback through this form, here!
If you want to use a number outside this range, you will need to convert it into a string by adding a non-numeric character to the field.
For example, you can force the source data to convert the number to a string by adding an apostrophe to the front - i.e. '21081100066000000000.
If you have a lot of numbers like this, you should be able to add another column and turn the number into string using a formula. Once the data is in Smartsheet, if you need it to be recognized as a numerical value, we can use another formula to wrap the VALUE function around this cell to convert it back. Does that make sense?
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
Hi @ygoldgrab
This is a current limitation of the Smartsheet API; to pass a number through the API, it must be larger than -9223372036854775808 and smaller than 9223372036854775807. Please let the Product team know about your use-case and feedback through this form, here!
If you want to use a number outside this range, you will need to convert it into a string by adding a non-numeric character to the field.
For example, you can force the source data to convert the number to a string by adding an apostrophe to the front - i.e. '21081100066000000000.
If you have a lot of numbers like this, you should be able to add another column and turn the number into string using a formula. Once the data is in Smartsheet, if you need it to be recognized as a numerical value, we can use another formula to wrap the VALUE function around this cell to convert it back. Does that make sense?
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Thank you
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives