New Case Study:See how Anthropic automated 95% of dependency reviews with Socket.Learn More
Socket
Sign inDemoInstall
Socket

smartsheet

Package Overview
Dependencies
Maintainers
1
Versions
39
Alerts
File Explorer

Advanced tools

Socket logo

Install Socket

Detect and block malicious and high-risk dependencies

Install

smartsheet - npm Package Compare versions

Comparing version 2.77.1 to 2.77.2

8

CHANGELOG.md

@@ -10,2 +10,10 @@ # Changelog

## 2.77.2 - Aug 9, 2019
- Updated the following dependencies due to security vulnerabilities:
- `set-value`
- `union-value`
- `mixin-deep`
- `lodash`
- `lodash.merge`
## 2.77.1 - June 6, 2019

@@ -12,0 +20,0 @@ - Updated `js-yaml` and `handlebars` dependencies due to security vulnerabilities

2

package.json
{
"name": "smartsheet",
"version": "2.77.1",
"version": "2.77.2",
"description": "Smartsheet JavaScript client SDK",

@@ -5,0 +5,0 @@ "main": "index.js",

@@ -177,2 +177,4 @@ # Smartsheet SDK for JavaScript [![Build Status](https://travis-ci.org/smartsheet-platform/smartsheet-javascript-sdk.svg?branch=master)](https://travis-ci.org/smartsheet-platform/smartsheet-javascript-sdk) [![Coverage Status](https://coveralls.io/repos/github/smartsheet-platform/smartsheet-javascript-sdk/badge.svg?branch=master)](https://coveralls.io/github/smartsheet-platform/smartsheet-javascript-sdk?branch=master) [![npm version](https://badge.fury.io/js/smartsheet.svg)](https://badge.fury.io/js/smartsheet)

Note that a successful test run will currently output some unhandled rejection messages in the body of the logs. This is expected, and does not indicate test failure.
## Passthrough Option

@@ -179,0 +181,0 @@

@@ -85,2 +85,3 @@ [

"backgroundColor": "#E2E2E2",
"permalink": "https://app.smartsheet.com/dashboards/Qv1",
"columnCount": 6,

@@ -92,8 +93,9 @@ "widgets": [

"contents": {
"type": "SHORTCUT",
"shortcutData": [
{
"label": "Starbucks Stores By State",
"labelFormat": ",2,,,,,1,,1,,,,,,,",
"labelFormat": ",2,,,,,1,,1,,,,,,,,",
"hyperlink": {
"url": "https://app.smartsheet.com/b/home",
"url": "https://app.smartsheet.com/sheets/r21",
"sheetId": 500

@@ -112,3 +114,3 @@ },

"showTitle": true,
"titleFormat": ",,1,,,,,,,3,,,,,,1",
"titleFormat": ",,1,,,,,,,3,,,,,,1,",
"version": 1

@@ -120,2 +122,7 @@ },

"contents": {
"type": "METRIC",
"hyperlink": {
"url": "http://www.seattle.gov/",
"interactionType": "WEB"
},
"cellData": [

@@ -125,7 +132,8 @@ {

"label": "Millimetres",
"labelFormat": ",2,,,,,,,1,,,,,,,1",
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1",
"labelFormat": ",2,,,,,,,1,,,,,,,1,",
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1,",
"order": 4,
"cell": {
"columnId": 236,
"rowId": 284,
"value": 958,

@@ -135,2 +143,3 @@ "objectValue": 958,

},
"dataSource": "CELL",
"objectValue": 958

@@ -141,7 +150,8 @@ },

"label": "State",
"labelFormat": ",2,,,,,,,1,,,,,,,1",
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1",
"labelFormat": ",2,,,,,,,1,,,,,,,1,",
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1,",
"order": 1,
"cell": {
"columnId": 492,
"rowId": 284,
"value": "Washington",

@@ -151,2 +161,3 @@ "objectValue": "Washington",

},
"dataSource": "CELL",
"objectValue": "Washington"

@@ -157,7 +168,8 @@ },

"label": "City",
"labelFormat": ",2,,,,,,,1,,,,,,,1",
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1",
"labelFormat": ",2,,,,,,,1,,,,,,,1,",
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1,",
"order": 0,
"cell": {
"columnId": 612,
"rowId": 284,
"value": "Seattle",

@@ -167,2 +179,3 @@ "objectValue": "Seattle",

},
"dataSource": "CELL",
"objectValue": "Seattle"

@@ -173,7 +186,8 @@ },

"label": "Inches",
"labelFormat": ",2,,,,,,,1,,,,,,,1",
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1",
"labelFormat": ",2,,,,,,,1,,,,,,,1,",
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1,",
"order": 3,
"cell": {
"columnId": 740,
"rowId": 284,
"value": 37.7,

@@ -183,2 +197,3 @@ "objectValue": 37.7,

},
"dataSource": "CELL",
"objectValue": 37.7

@@ -189,7 +204,8 @@ },

"label": "Days",
"labelFormat": ",2,,,,,,,1,,,,,,,1",
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1",
"labelFormat": ",2,,,,,,,1,,,,,,,1,",
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1,",
"order": 2,
"cell": {
"columnId": 988,
"rowId": 284,
"value": 149,

@@ -199,2 +215,3 @@ "objectValue": 149,

},
"dataSource": "CELL",
"objectValue": 149

@@ -206,2 +223,3 @@ }

"id": 612,
"version": 0,
"index": 0,

@@ -216,2 +234,3 @@ "title": "City",

"id": 492,
"version": 0,
"index": 1,

@@ -225,2 +244,3 @@ "title": "State",

"id": 988,
"version": 0,
"index": 2,

@@ -234,2 +254,3 @@ "title": "Days",

"id": 740,
"version": 0,
"index": 3,

@@ -243,2 +264,3 @@ "title": "Inches",

"id": 236,
"version": 0,
"index": 4,

@@ -251,3 +273,3 @@ "title": "Millimetres",

],
"gridID": 10624640
"sheetId": 524
},

@@ -261,3 +283,3 @@ "xPosition": 1,

"showTitle": true,
"titleFormat": ",,1,,,,,,,3,,,,,,1",
"titleFormat": ",,1,,,,,,,3,,,,,,1,",
"version": 1

@@ -269,2 +291,3 @@ },

"contents": {
"type": "RICHTEXT",
"htmlContent": "<p>This is a&nbsp;<span class=\"clsDbFt\" style=\"font-family:'arial';font-size:10pt;font-weight:bold;font-style:normal;text-decoration:none;color:rgb( 0 , 0 , 0 );background-color:rgb( 255 , 255 , 255 )\">rich</span><span class=\"clsDbFt\" style=\"font-family:'arial';font-size:10pt;font-weight:normal;font-style:italic;text-decoration:none;color:rgb( 0 , 0 , 0 );background-color:rgb( 255 , 255 , 255 )\">text&nbsp;</span><span class=\"clsDbFt\" style=\"font-family:'arial';font-size:10pt;font-weight:normal;font-style:normal;text-decoration:none;color:rgb( 0 , 0 , 0 );background-color:rgb( 255 , 255 , 255 )\">test</span></p>"

@@ -281,24 +304,13 @@ },

{
"id": 612,
"type": "IMAGE",
"contents": {
"privateId": "TCA",
"height": 18,
"width": 18,
"fileName": "info_tip_16x16.png",
"format": ",7,1,,,,2,2,1,3,,,,,,1"
},
"xPosition": 4,
"yPosition": 1,
"width": 1,
"height": 4,
"showTitleIcon": false,
"showTitle": false,
"version": 1
},
{
"id": 108,
"type": "GRIDGANTT",
"contents": {
"htmlContent": "<style type=\"text/css\">"
"type": "GRIDGANTT",
"hyperlink": {
"url": "https://app.smartsheet.com/reports/J81",
"reportId": 876,
"interactionType": "SOURCE_SHEET"
},
"htmlContent": "<style type=\"text/css\">",
"reportId": 876
},

@@ -317,4 +329,5 @@ "xPosition": 0,

"contents": {
"htmlContent": "<p style=\"text-align:center\"><span class=\"clsDbFt\">This is my title</span></p>",
"backgroundColor": "#F7F7F7"
"type": "RICHTEXT",
"htmlContent": "<p style=\"text-align:center\"><span class=\"clsDbFt\" style=\"font-family:&#39;arial&#39;;font-size:20pt;font-weight:bold;font-style:normal;text-decoration:none;color:rgb( 0 , 0 , 0 )\"></span><span class=\"clsDbFt\">This is my title</span></p>",
"backgroundColor": "#D0AF8F"
},

@@ -330,47 +343,551 @@ "xPosition": 0,

{
"id": 852,
"type": "SHEETSUMMARY",
"id": 796,
"type": "CHART",
"contents": {
"type": "CHART",
"hyperlink": {
"url": "http://www.somesite.com"
"url": "https://app.smartsheet.com/sheets/9J1",
"sheetId": 660,
"interactionType": "SMARTSHEET_ITEM"
},
"cellData": [
"series": [
{
"columnId": 788,
"label": "Population (July 1, 2013)",
"labelFormat": ",2,,,,,,,1,,,,,,,1",
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1",
"order": 0,
"cell": {
"columnId": 788,
"value": 6971406,
"objectValue": 6971406,
"displayValue": "6971406"
"title": "Days",
"titleInfo": {
"type": "TEXT_NUMBER"
},
"objectValue": 6971406
"seriesType": "COLUMN",
"tooltips": {
"labelType": "X-SERIES-Y"
},
"color": "#1061C3",
"axisLocationX": "BOTTOM",
"axisLocationY": "LEFT",
"yColumnInfo": {
"type": "TEXT_NUMBER"
},
"xColumnInfo": {
"type": "TEXT_NUMBER"
},
"seriesData": [
{
"y": 113
},
{
"x": "Austin",
"y": 88
},
{
"x": "Baltimore",
"y": 116
},
{
"x": "Birmingham",
"y": 117
},
{
"x": "Boston",
"y": 126
},
{
"x": "Buffalo",
"y": 167
},
{
"x": "Charlotte",
"y": 110
},
{
"x": "Chicago",
"y": 124
},
{
"x": "Cincinnati",
"y": 137
},
{
"x": "Cleveland",
"y": 155
},
{
"x": "Columbus",
"y": 139
},
{
"x": "Dallas",
"y": 81
},
{
"x": "Denver",
"y": 87
},
{
"x": "Detroit",
"y": 135
},
{
"x": "Hartford",
"y": 130
},
{
"x": "Houston",
"y": 104
},
{
"x": "Indianapolis",
"y": 129
},
{
"x": "Jacksonville",
"y": 114
},
{
"x": "Kansas City",
"y": 91
},
{
"x": "Las Vegas",
"y": 27
},
{
"x": "Los Angeles",
"y": 36
},
{
"x": "Louisville",
"y": 123
},
{
"x": "Memphis",
"y": 108
},
{
"x": "Miami",
"y": 135
},
{
"x": "Milwaukee",
"y": 127
},
{
"x": "Minneapolis",
"y": 117
},
{
"x": "Nashville",
"y": 119
},
{
"x": "New Orleans",
"y": 115
},
{
"x": "New York",
"y": 122
},
{
"x": "Oklahoma City",
"y": 84
},
{
"x": "Orlando",
"y": 117
},
{
"x": "Philadelphia",
"y": 118
},
{
"x": "Phoenix",
"y": 30
},
{
"x": "Pittsburgh",
"y": 151
},
{
"x": "Portland",
"y": 164
},
{
"x": "Providence",
"y": 125
},
{
"x": "Raleigh",
"y": 100
},
{
"x": "Richmond",
"y": 114
},
{
"x": "Riverside",
"y": 30
},
{
"x": "Rochester",
"y": 167
},
{
"x": "Sacramento",
"y": 60
},
{
"x": "Salt Lake City",
"y": 96
},
{
"x": "San Antonio",
"y": 83
},
{
"x": "San Diego",
"y": 42
},
{
"x": "San Francisco",
"y": 68
},
{
"x": "San Jose",
"y": 62
},
{
"x": "Seattle",
"y": 149
},
{
"x": "St. Louis",
"y": 113
},
{
"x": "Tampa",
"y": 105
},
{
"x": "Virginia Beach",
"y": 117
},
{
"x": "Washington",
"y": 114
}
],
"selectionRanges": [
{
"sourceRowId1": 292,
"sourceRowId2": 908,
"sourceColumnId1": 988,
"sourceColumnId2": 988
}
]
},
{
"title": "Inches",
"titleInfo": {
"type": "TEXT_NUMBER"
},
"seriesType": "COLUMN",
"tooltips": {
"labelType": "X-SERIES-Y"
},
"color": "#EA352E",
"axisLocationX": "BOTTOM",
"axisLocationY": "LEFT",
"yColumnInfo": {
"type": "TEXT_NUMBER"
},
"xColumnInfo": {
"type": "TEXT_NUMBER"
},
"seriesData": [
{
"y": 49.7
},
{
"x": "Austin",
"y": 34.2
},
{
"x": "Baltimore",
"y": 41.9
},
{
"x": "Birmingham",
"y": 53.7
},
{
"x": "Boston",
"y": 43.8
},
{
"x": "Buffalo",
"y": 40.5
},
{
"x": "Charlotte",
"y": 41.6
},
{
"x": "Chicago",
"y": 36.9
},
{
"x": "Cincinnati",
"y": 41.9
},
{
"x": "Cleveland",
"y": 39.1
},
{
"x": "Columbus",
"y": 39.3
},
{
"x": "Dallas",
"y": 37.6
},
{
"x": "Denver",
"y": 15.6
},
{
"x": "Detroit",
"y": 33.5
},
{
"x": "Hartford",
"y": 45.9
},
{
"x": "Houston",
"y": 49.8
},
{
"x": "Indianapolis",
"y": 42.4
},
{
"x": "Jacksonville",
"y": 52.4
},
{
"x": "Kansas City",
"y": 39.1
},
{
"x": "Las Vegas",
"y": 4.2
},
{
"x": "Los Angeles",
"y": 12.8
},
{
"x": "Louisville",
"y": 44.9
},
{
"x": "Memphis",
"y": 53.7
},
{
"x": "Miami",
"y": 61.9
},
{
"x": "Milwaukee",
"y": 34.8
},
{
"x": "Minneapolis",
"y": 30.6
},
{
"x": "Nashville",
"y": 47.3
},
{
"x": "New Orleans",
"y": 62.7
},
{
"x": "New York",
"y": 49.9
},
{
"x": "Oklahoma City",
"y": 36.5
},
{
"x": "Orlando",
"y": 50.7
},
{
"x": "Philadelphia",
"y": 41.5
},
{
"x": "Phoenix",
"y": 8.2
},
{
"x": "Pittsburgh",
"y": 38.2
},
{
"x": "Portland",
"y": 43.5
},
{
"x": "Providence",
"y": 47.2
},
{
"x": "Raleigh",
"y": 46
},
{
"x": "Richmond",
"y": 43.6
},
{
"x": "Riverside",
"y": 10.3
},
{
"x": "Rochester",
"y": 34.3
},
{
"x": "Sacramento",
"y": 18.5
},
{
"x": "Salt Lake City",
"y": 16.1
},
{
"x": "San Antonio",
"y": 32.3
},
{
"x": "San Diego",
"y": 10.3
},
{
"x": "San Francisco",
"y": 20.7
},
{
"x": "San Jose",
"y": 15.8
},
{
"x": "Seattle",
"y": 37.7
},
{
"x": "St. Louis",
"y": 41
},
{
"x": "Tampa",
"y": 46.3
},
{
"x": "Virginia Beach",
"y": 46.5
},
{
"x": "Washington",
"y": 39.7
}
],
"selectionRanges": [
{
"sourceRowId1": 292,
"sourceRowId2": 908,
"sourceColumnId1": 740,
"sourceColumnId2": 740
}
]
}
],
"columns": [
"axes": [
{
"id": 788,
"index": 2,
"title": "Population (July 1, 2013)",
"type": "TEXT_NUMBER",
"validation": false,
"width": 150
"location": "LEFT",
"includeZero": true
},
{
"location": "BOTTOM"
}
],
"gridID": 10624332
"legend": {
"location": "RIGHT"
},
"sheetId": 524,
"selectionRanges": [
{
"sourceRowId1": 292,
"sourceRowId2": 908,
"sourceColumnId1": 612,
"sourceColumnId2": 740
}
]
},
"xPosition": 0,
"yPosition": 11,
"width": 4,
"height": 6,
"title": "Annual Averages for Total Precipitation By City",
"showTitleIcon": false,
"showTitle": true,
"titleFormat": ",,1,,,,,,,3,,,,,,1,",
"version": 1
},
{
"id": 932,
"type": "IMAGE",
"contents": {
"type": "IMAGE",
"hyperlink": {
"url": "http://www.smartsheet.com",
"interactionType": "WEB"
},
"privateId": "_kpnN9Q",
"height": 48,
"width": 197,
"fileName": "smartsheet-logo-blue-197x48.png",
"format": ",7,1,,,,2,2,1,3,,,,,,1,"
},
"xPosition": 4,
"yPosition": 5,
"yPosition": 1,
"width": 1,
"height": 2,
"title": "Starbucks Stores By State",
"showTitleIcon": true,
"height": 4,
"showTitleIcon": false,
"showTitle": false,
"version": 1
},
{
"id": 636,
"type": "WEBCONTENT",
"contents": {
"type": "WidgetWebContent",
"url": "https://www.youtube.com/"
},
"xPosition": 0,
"yPosition": 17,
"width": 4,
"height": 6,
"showTitleIcon": false,
"showTitle": true,
"titleFormat": ",,1,,,,,,,3,,,,,,1",
"titleFormat": ",,1,,,,,,,3,,,,,,1,",
"version": 1
}
]
],
"createdAt": "2016-08-14T23:45:06Z",
"modifiedAt": "2019-07-12T22:25:42Z"
}

@@ -433,14 +950,16 @@ }

"backgroundColor": "#E2E2E2",
"permalink": "https://app.smartsheet.com/dashboards/PP1",
"columnCount": 6,
"widgets": [
{
"id": 556,
"id": 532,
"type": "SHORTCUTLIST",
"contents": {
"type": "SHORTCUT",
"shortcutData": [
{
"label": "Starbucks Stores By State",
"labelFormat": ",2,,,,,1,,1,,,,,,,",
"labelFormat": ",2,,,,,1,,1,,,,,,,,",
"hyperlink": {
"url": "https://app.smartsheet.com/b/home",
"url": "https://app.smartsheet.com/sheets/r21",
"sheetId": 500

@@ -459,9 +978,14 @@ },

"showTitle": true,
"titleFormat": ",,1,,,,,,,3,,,,,,1",
"titleFormat": ",,1,,,,,,,3,,,,,,1,",
"version": 1
},
{
"id": 500,
"id": 28,
"type": "SHEETSUMMARY",
"contents": {
"type": "METRIC",
"hyperlink": {
"url": "http://www.seattle.gov/",
"interactionType": "WEB"
},
"cellData": [

@@ -471,7 +995,8 @@ {

"label": "Millimetres",
"labelFormat": ",2,,,,,,,1,,,,,,,1",
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1",
"labelFormat": ",2,,,,,,,1,,,,,,,1,",
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1,",
"order": 4,
"cell": {
"columnId": 236,
"rowId": 284,
"value": 958,

@@ -481,2 +1006,3 @@ "objectValue": 958,

},
"dataSource": "CELL",
"objectValue": 958

@@ -487,7 +1013,8 @@ },

"label": "State",
"labelFormat": ",2,,,,,,,1,,,,,,,1",
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1",
"labelFormat": ",2,,,,,,,1,,,,,,,1,",
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1,",
"order": 1,
"cell": {
"columnId": 492,
"rowId": 284,
"value": "Washington",

@@ -497,2 +1024,3 @@ "objectValue": "Washington",

},
"dataSource": "CELL",
"objectValue": "Washington"

@@ -503,7 +1031,8 @@ },

"label": "City",
"labelFormat": ",2,,,,,,,1,,,,,,,1",
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1",
"labelFormat": ",2,,,,,,,1,,,,,,,1,",
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1,",
"order": 0,
"cell": {
"columnId": 612,
"rowId": 284,
"value": "Seattle",

@@ -513,2 +1042,3 @@ "objectValue": "Seattle",

},
"dataSource": "CELL",
"objectValue": "Seattle"

@@ -519,7 +1049,8 @@ },

"label": "Inches",
"labelFormat": ",2,,,,,,,1,,,,,,,1",
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1",
"labelFormat": ",2,,,,,,,1,,,,,,,1,",
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1,",
"order": 3,
"cell": {
"columnId": 740,
"rowId": 284,
"value": 37.7,

@@ -529,2 +1060,3 @@ "objectValue": 37.7,

},
"dataSource": "CELL",
"objectValue": 37.7

@@ -535,7 +1067,8 @@ },

"label": "Days",
"labelFormat": ",2,,,,,,,1,,,,,,,1",
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1",
"labelFormat": ",2,,,,,,,1,,,,,,,1,",
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1,",
"order": 2,
"cell": {
"columnId": 988,
"rowId": 284,
"value": 149,

@@ -545,2 +1078,3 @@ "objectValue": 149,

},
"dataSource": "CELL",
"objectValue": 149

@@ -552,2 +1086,3 @@ }

"id": 612,
"version": 0,
"index": 0,

@@ -562,2 +1097,3 @@ "title": "City",

"id": 492,
"version": 0,
"index": 1,

@@ -571,2 +1107,3 @@ "title": "State",

"id": 988,
"version": 0,
"index": 2,

@@ -580,2 +1117,3 @@ "title": "Days",

"id": 740,
"version": 0,
"index": 3,

@@ -589,2 +1127,3 @@ "title": "Inches",

"id": 236,
"version": 0,
"index": 4,

@@ -597,3 +1136,3 @@ "title": "Millimetres",

],
"gridID": 10624640
"sheetId": 524
},

@@ -607,9 +1146,10 @@ "xPosition": 1,

"showTitle": true,
"titleFormat": ",,1,,,,,,,3,,,,,,1",
"titleFormat": ",,1,,,,,,,3,,,,,,1,",
"version": 1
},
{
"id": 5371172654212996,
"id": 20,
"type": "RICHTEXT",
"contents": {
"type": "RICHTEXT",
"htmlContent": "<p>This is a&nbsp;<span class=\"clsDbFt\" style=\"font-family:'arial';font-size:10pt;font-weight:bold;font-style:normal;text-decoration:none;color:rgb( 0 , 0 , 0 );background-color:rgb( 255 , 255 , 255 )\">rich</span><span class=\"clsDbFt\" style=\"font-family:'arial';font-size:10pt;font-weight:normal;font-style:italic;text-decoration:none;color:rgb( 0 , 0 , 0 );background-color:rgb( 255 , 255 , 255 )\">text&nbsp;</span><span class=\"clsDbFt\" style=\"font-family:'arial';font-size:10pt;font-weight:normal;font-style:normal;text-decoration:none;color:rgb( 0 , 0 , 0 );background-color:rgb( 255 , 255 , 255 )\">test</span></p>"

@@ -626,24 +1166,13 @@ },

{
"id": 748,
"type": "IMAGE",
"contents": {
"privateId": "TCA",
"height": 18,
"width": 18,
"fileName": "info_tip_16x16.png",
"format": ",7,1,,,,2,2,1,3,,,,,,1"
},
"xPosition": 4,
"yPosition": 1,
"width": 1,
"height": 4,
"showTitleIcon": false,
"showTitle": false,
"version": 1
},
{
"id": 244,
"id": 516,
"type": "GRIDGANTT",
"contents": {
"htmlContent": "<style type=\"text/css\">"
"type": "GRIDGANTT",
"hyperlink": {
"url": "https://app.smartsheet.com/reports/J81",
"reportId": 876,
"interactionType": "SOURCE_SHEET"
},
"htmlContent": "<style type=\"text/css\">",
"reportId": 876
},

@@ -659,7 +1188,8 @@ "xPosition": 0,

{
"id": 124,
"id": 268,
"type": "TITLE",
"contents": {
"htmlContent": "<p style=\"text-align:center\"><span class=\"clsDbFt\">This is my title</span></p>",
"backgroundColor": "#F7F7F7"
"type": "RICHTEXT",
"htmlContent": "<p style=\"text-align:center\"><span class=\"clsDbFt\" style=\"font-family:&#39;arial&#39;;font-size:20pt;font-weight:bold;font-style:normal;text-decoration:none;color:rgb( 0 , 0 , 0 )\"></span><span class=\"clsDbFt\">This is my title</span></p>",
"backgroundColor": "#D0AF8F"
},

@@ -675,47 +1205,551 @@ "xPosition": 0,

{
"id": 620,
"type": "SHEETSUMMARY",
"id": 764,
"type": "CHART",
"contents": {
"type": "CHART",
"hyperlink": {
"url": "http://www.somesite.com"
"url": "https://app.smartsheet.com/sheets/9J1",
"sheetId": 660,
"interactionType": "SMARTSHEET_ITEM"
},
"cellData": [
"series": [
{
"columnId": 788,
"label": "Population (July 1, 2013)",
"labelFormat": ",2,,,,,,,1,,,,,,,1",
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1",
"order": 0,
"cell": {
"columnId": 788,
"value": 6971406,
"objectValue": 6971406,
"displayValue": "6971406"
"title": "Days",
"titleInfo": {
"type": "TEXT_NUMBER"
},
"objectValue": 6971406
"seriesType": "COLUMN",
"tooltips": {
"labelType": "X-SERIES-Y"
},
"color": "#1061C3",
"axisLocationX": "BOTTOM",
"axisLocationY": "LEFT",
"yColumnInfo": {
"type": "TEXT_NUMBER"
},
"xColumnInfo": {
"type": "TEXT_NUMBER"
},
"seriesData": [
{
"y": 113
},
{
"x": "Austin",
"y": 88
},
{
"x": "Baltimore",
"y": 116
},
{
"x": "Birmingham",
"y": 117
},
{
"x": "Boston",
"y": 126
},
{
"x": "Buffalo",
"y": 167
},
{
"x": "Charlotte",
"y": 110
},
{
"x": "Chicago",
"y": 124
},
{
"x": "Cincinnati",
"y": 137
},
{
"x": "Cleveland",
"y": 155
},
{
"x": "Columbus",
"y": 139
},
{
"x": "Dallas",
"y": 81
},
{
"x": "Denver",
"y": 87
},
{
"x": "Detroit",
"y": 135
},
{
"x": "Hartford",
"y": 130
},
{
"x": "Houston",
"y": 104
},
{
"x": "Indianapolis",
"y": 129
},
{
"x": "Jacksonville",
"y": 114
},
{
"x": "Kansas City",
"y": 91
},
{
"x": "Las Vegas",
"y": 27
},
{
"x": "Los Angeles",
"y": 36
},
{
"x": "Louisville",
"y": 123
},
{
"x": "Memphis",
"y": 108
},
{
"x": "Miami",
"y": 135
},
{
"x": "Milwaukee",
"y": 127
},
{
"x": "Minneapolis",
"y": 117
},
{
"x": "Nashville",
"y": 119
},
{
"x": "New Orleans",
"y": 115
},
{
"x": "New York",
"y": 122
},
{
"x": "Oklahoma City",
"y": 84
},
{
"x": "Orlando",
"y": 117
},
{
"x": "Philadelphia",
"y": 118
},
{
"x": "Phoenix",
"y": 30
},
{
"x": "Pittsburgh",
"y": 151
},
{
"x": "Portland",
"y": 164
},
{
"x": "Providence",
"y": 125
},
{
"x": "Raleigh",
"y": 100
},
{
"x": "Richmond",
"y": 114
},
{
"x": "Riverside",
"y": 30
},
{
"x": "Rochester",
"y": 167
},
{
"x": "Sacramento",
"y": 60
},
{
"x": "Salt Lake City",
"y": 96
},
{
"x": "San Antonio",
"y": 83
},
{
"x": "San Diego",
"y": 42
},
{
"x": "San Francisco",
"y": 68
},
{
"x": "San Jose",
"y": 62
},
{
"x": "Seattle",
"y": 149
},
{
"x": "St. Louis",
"y": 113
},
{
"x": "Tampa",
"y": 105
},
{
"x": "Virginia Beach",
"y": 117
},
{
"x": "Washington",
"y": 114
}
],
"selectionRanges": [
{
"sourceRowId1": 292,
"sourceRowId2": 908,
"sourceColumnId1": 988,
"sourceColumnId2": 988
}
]
},
{
"title": "Inches",
"titleInfo": {
"type": "TEXT_NUMBER"
},
"seriesType": "COLUMN",
"tooltips": {
"labelType": "X-SERIES-Y"
},
"color": "#EA352E",
"axisLocationX": "BOTTOM",
"axisLocationY": "LEFT",
"yColumnInfo": {
"type": "TEXT_NUMBER"
},
"xColumnInfo": {
"type": "TEXT_NUMBER"
},
"seriesData": [
{
"y": 49.7
},
{
"x": "Austin",
"y": 34.2
},
{
"x": "Baltimore",
"y": 41.9
},
{
"x": "Birmingham",
"y": 53.7
},
{
"x": "Boston",
"y": 43.8
},
{
"x": "Buffalo",
"y": 40.5
},
{
"x": "Charlotte",
"y": 41.6
},
{
"x": "Chicago",
"y": 36.9
},
{
"x": "Cincinnati",
"y": 41.9
},
{
"x": "Cleveland",
"y": 39.1
},
{
"x": "Columbus",
"y": 39.3
},
{
"x": "Dallas",
"y": 37.6
},
{
"x": "Denver",
"y": 15.6
},
{
"x": "Detroit",
"y": 33.5
},
{
"x": "Hartford",
"y": 45.9
},
{
"x": "Houston",
"y": 49.8
},
{
"x": "Indianapolis",
"y": 42.4
},
{
"x": "Jacksonville",
"y": 52.4
},
{
"x": "Kansas City",
"y": 39.1
},
{
"x": "Las Vegas",
"y": 4.2
},
{
"x": "Los Angeles",
"y": 12.8
},
{
"x": "Louisville",
"y": 44.9
},
{
"x": "Memphis",
"y": 53.7
},
{
"x": "Miami",
"y": 61.9
},
{
"x": "Milwaukee",
"y": 34.8
},
{
"x": "Minneapolis",
"y": 30.6
},
{
"x": "Nashville",
"y": 47.3
},
{
"x": "New Orleans",
"y": 62.7
},
{
"x": "New York",
"y": 49.9
},
{
"x": "Oklahoma City",
"y": 36.5
},
{
"x": "Orlando",
"y": 50.7
},
{
"x": "Philadelphia",
"y": 41.5
},
{
"x": "Phoenix",
"y": 8.2
},
{
"x": "Pittsburgh",
"y": 38.2
},
{
"x": "Portland",
"y": 43.5
},
{
"x": "Providence",
"y": 47.2
},
{
"x": "Raleigh",
"y": 46
},
{
"x": "Richmond",
"y": 43.6
},
{
"x": "Riverside",
"y": 10.3
},
{
"x": "Rochester",
"y": 34.3
},
{
"x": "Sacramento",
"y": 18.5
},
{
"x": "Salt Lake City",
"y": 16.1
},
{
"x": "San Antonio",
"y": 32.3
},
{
"x": "San Diego",
"y": 10.3
},
{
"x": "San Francisco",
"y": 20.7
},
{
"x": "San Jose",
"y": 15.8
},
{
"x": "Seattle",
"y": 37.7
},
{
"x": "St. Louis",
"y": 41
},
{
"x": "Tampa",
"y": 46.3
},
{
"x": "Virginia Beach",
"y": 46.5
},
{
"x": "Washington",
"y": 39.7
}
],
"selectionRanges": [
{
"sourceRowId1": 292,
"sourceRowId2": 908,
"sourceColumnId1": 740,
"sourceColumnId2": 740
}
]
}
],
"columns": [
"axes": [
{
"id": 788,
"index": 2,
"title": "Population (July 1, 2013)",
"type": "TEXT_NUMBER",
"validation": false,
"width": 150
"location": "LEFT",
"includeZero": true
},
{
"location": "BOTTOM"
}
],
"gridID": 10624332
"legend": {
"location": "RIGHT"
},
"sheetId": 524,
"selectionRanges": [
{
"sourceRowId1": 292,
"sourceRowId2": 908,
"sourceColumnId1": 612,
"sourceColumnId2": 740
}
]
},
"xPosition": 0,
"yPosition": 11,
"width": 4,
"height": 6,
"title": "Annual Averages for Total Precipitation By City",
"showTitleIcon": false,
"showTitle": true,
"titleFormat": ",,1,,,,,,,3,,,,,,1,",
"version": 1
},
{
"id": 644,
"type": "IMAGE",
"contents": {
"type": "IMAGE",
"hyperlink": {
"url": "http://www.smartsheet.com",
"interactionType": "WEB"
},
"privateId": "Jppz",
"height": 48,
"width": 197,
"fileName": "smartsheet-logo-blue-197x48.png",
"format": ",7,1,,,,2,2,1,3,,,,,,1,"
},
"xPosition": 4,
"yPosition": 5,
"yPosition": 1,
"width": 1,
"height": 2,
"title": "Starbucks Stores By State",
"showTitleIcon": true,
"height": 4,
"showTitleIcon": false,
"showTitle": false,
"version": 1
},
{
"id": 140,
"type": "WEBCONTENT",
"contents": {
"type": "WidgetWebContent",
"url": "https://www.youtube.com/"
},
"xPosition": 0,
"yPosition": 17,
"width": 4,
"height": 6,
"showTitleIcon": false,
"showTitle": true,
"titleFormat": ",,1,,,,,,,3,,,,,,1",
"titleFormat": ",,1,,,,,,,3,,,,,,1,",
"version": 1
}
]
],
"createdAt": "2019-08-07T20:12:02Z",
"modifiedAt": "2019-08-07T20:12:02Z"
}

@@ -722,0 +1756,0 @@ }

@@ -24,10 +24,10 @@ {

"dependencies": {
"colors": "^1.1.2",
"underscore": "^1.8.3",
"yargs": "^10.0.3"
"colors": "^1.3.3",
"underscore": "^1.9.1",
"yargs": "^13.3.0"
},
"devDependencies": {
"mocha": "^4.0.1",
"should": "^13.1.3"
"mocha": "^6.2.0",
"should": "^13.2.3"
}
}

@@ -19,2 +19,3 @@ {

"backgroundColor": "#E2E2E2",
"permalink": "https://app.smartsheet.com/dashboards/Qv1",
"columnCount": 6,

@@ -26,8 +27,9 @@ "widgets": [

"contents": {
"type": "SHORTCUT",
"shortcutData": [
{
"label": "Starbucks Stores By State",
"labelFormat": ",2,,,,,1,,1,,,,,,,",
"labelFormat": ",2,,,,,1,,1,,,,,,,,",
"hyperlink": {
"url": "https://app.smartsheet.com/b/home",
"url": "https://app.smartsheet.com/sheets/r21",
"sheetId": 500

@@ -46,3 +48,3 @@ },

"showTitle": true,
"titleFormat": ",,1,,,,,,,3,,,,,,1",
"titleFormat": ",,1,,,,,,,3,,,,,,1,",
"version": 1

@@ -54,2 +56,7 @@ },

"contents": {
"type": "METRIC",
"hyperlink": {
"url": "http://www.seattle.gov/",
"interactionType": "WEB"
},
"cellData": [

@@ -59,7 +66,8 @@ {

"label": "Millimetres",
"labelFormat": ",2,,,,,,,1,,,,,,,1",
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1",
"labelFormat": ",2,,,,,,,1,,,,,,,1,",
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1,",
"order": 4,
"cell": {
"columnId": 236,
"rowId": 284,
"value": 958,

@@ -69,2 +77,3 @@ "objectValue": 958,

},
"dataSource": "CELL",
"objectValue": 958

@@ -75,7 +84,8 @@ },

"label": "State",
"labelFormat": ",2,,,,,,,1,,,,,,,1",
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1",
"labelFormat": ",2,,,,,,,1,,,,,,,1,",
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1,",
"order": 1,
"cell": {
"columnId": 492,
"rowId": 284,
"value": "Washington",

@@ -85,2 +95,3 @@ "objectValue": "Washington",

},
"dataSource": "CELL",
"objectValue": "Washington"

@@ -91,7 +102,8 @@ },

"label": "City",
"labelFormat": ",2,,,,,,,1,,,,,,,1",
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1",
"labelFormat": ",2,,,,,,,1,,,,,,,1,",
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1,",
"order": 0,
"cell": {
"columnId": 612,
"rowId": 284,
"value": "Seattle",

@@ -101,2 +113,3 @@ "objectValue": "Seattle",

},
"dataSource": "CELL",
"objectValue": "Seattle"

@@ -107,7 +120,8 @@ },

"label": "Inches",
"labelFormat": ",2,,,,,,,1,,,,,,,1",
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1",
"labelFormat": ",2,,,,,,,1,,,,,,,1,",
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1,",
"order": 3,
"cell": {
"columnId": 740,
"rowId": 284,
"value": 37.7,

@@ -117,2 +131,3 @@ "objectValue": 37.7,

},
"dataSource": "CELL",
"objectValue": 37.7

@@ -123,7 +138,8 @@ },

"label": "Days",
"labelFormat": ",2,,,,,,,1,,,,,,,1",
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1",
"labelFormat": ",2,,,,,,,1,,,,,,,1,",
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1,",
"order": 2,
"cell": {
"columnId": 988,
"rowId": 284,
"value": 149,

@@ -133,2 +149,3 @@ "objectValue": 149,

},
"dataSource": "CELL",
"objectValue": 149

@@ -140,2 +157,3 @@ }

"id": 612,
"version": 0,
"index": 0,

@@ -150,2 +168,3 @@ "title": "City",

"id": 492,
"version": 0,
"index": 1,

@@ -159,2 +178,3 @@ "title": "State",

"id": 988,
"version": 0,
"index": 2,

@@ -168,2 +188,3 @@ "title": "Days",

"id": 740,
"version": 0,
"index": 3,

@@ -177,2 +198,3 @@ "title": "Inches",

"id": 236,
"version": 0,
"index": 4,

@@ -185,3 +207,3 @@ "title": "Millimetres",

],
"gridID": 10624640
"sheetId": 524
},

@@ -195,3 +217,3 @@ "xPosition": 1,

"showTitle": true,
"titleFormat": ",,1,,,,,,,3,,,,,,1",
"titleFormat": ",,1,,,,,,,3,,,,,,1,",
"version": 1

@@ -203,2 +225,3 @@ },

"contents": {
"type": "RICHTEXT",
"htmlContent": "<p>This is a&nbsp;<span class=\"clsDbFt\" style=\"font-family:'arial';font-size:10pt;font-weight:bold;font-style:normal;text-decoration:none;color:rgb( 0 , 0 , 0 );background-color:rgb( 255 , 255 , 255 )\">rich</span><span class=\"clsDbFt\" style=\"font-family:'arial';font-size:10pt;font-weight:normal;font-style:italic;text-decoration:none;color:rgb( 0 , 0 , 0 );background-color:rgb( 255 , 255 , 255 )\">text&nbsp;</span><span class=\"clsDbFt\" style=\"font-family:'arial';font-size:10pt;font-weight:normal;font-style:normal;text-decoration:none;color:rgb( 0 , 0 , 0 );background-color:rgb( 255 , 255 , 255 )\">test</span></p>"

@@ -215,24 +238,13 @@ },

{
"id": 612,
"type": "IMAGE",
"contents": {
"privateId": "TCA",
"height": 18,
"width": 18,
"fileName": "info_tip_16x16.png",
"format": ",7,1,,,,2,2,1,3,,,,,,1"
},
"xPosition": 4,
"yPosition": 1,
"width": 1,
"height": 4,
"showTitleIcon": false,
"showTitle": false,
"version": 1
},
{
"id": 108,
"type": "GRIDGANTT",
"contents": {
"htmlContent": "<style type=\"text/css\">"
"type": "GRIDGANTT",
"hyperlink": {
"url": "https://app.smartsheet.com/reports/J81",
"reportId": 876,
"interactionType": "SOURCE_SHEET"
},
"htmlContent": "<style type=\"text/css\">",
"reportId": 876
},

@@ -251,4 +263,5 @@ "xPosition": 0,

"contents": {
"htmlContent": "<p style=\"text-align:center\"><span class=\"clsDbFt\">This is my title</span></p>",
"backgroundColor": "#F7F7F7"
"type": "RICHTEXT",
"htmlContent": "<p style=\"text-align:center\"><span class=\"clsDbFt\" style=\"font-family:&#39;arial&#39;;font-size:20pt;font-weight:bold;font-style:normal;text-decoration:none;color:rgb( 0 , 0 , 0 )\"></span><span class=\"clsDbFt\">This is my title</span></p>",
"backgroundColor": "#D0AF8F"
},

@@ -264,47 +277,551 @@ "xPosition": 0,

{
"id": 852,
"type": "SHEETSUMMARY",
"id": 796,
"type": "CHART",
"contents": {
"type": "CHART",
"hyperlink": {
"url": "http://www.somesite.com"
"url": "https://app.smartsheet.com/sheets/9J1",
"sheetId": 660,
"interactionType": "SMARTSHEET_ITEM"
},
"cellData": [
"series": [
{
"columnId": 788,
"label": "Population (July 1, 2013)",
"labelFormat": ",2,,,,,,,1,,,,,,,1",
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1",
"order": 0,
"cell": {
"columnId": 788,
"value": 6971406,
"objectValue": 6971406,
"displayValue": "6971406"
"title": "Days",
"titleInfo": {
"type": "TEXT_NUMBER"
},
"objectValue": 6971406
"seriesType": "COLUMN",
"tooltips": {
"labelType": "X-SERIES-Y"
},
"color": "#1061C3",
"axisLocationX": "BOTTOM",
"axisLocationY": "LEFT",
"yColumnInfo": {
"type": "TEXT_NUMBER"
},
"xColumnInfo": {
"type": "TEXT_NUMBER"
},
"seriesData": [
{
"y": 113
},
{
"x": "Austin",
"y": 88
},
{
"x": "Baltimore",
"y": 116
},
{
"x": "Birmingham",
"y": 117
},
{
"x": "Boston",
"y": 126
},
{
"x": "Buffalo",
"y": 167
},
{
"x": "Charlotte",
"y": 110
},
{
"x": "Chicago",
"y": 124
},
{
"x": "Cincinnati",
"y": 137
},
{
"x": "Cleveland",
"y": 155
},
{
"x": "Columbus",
"y": 139
},
{
"x": "Dallas",
"y": 81
},
{
"x": "Denver",
"y": 87
},
{
"x": "Detroit",
"y": 135
},
{
"x": "Hartford",
"y": 130
},
{
"x": "Houston",
"y": 104
},
{
"x": "Indianapolis",
"y": 129
},
{
"x": "Jacksonville",
"y": 114
},
{
"x": "Kansas City",
"y": 91
},
{
"x": "Las Vegas",
"y": 27
},
{
"x": "Los Angeles",
"y": 36
},
{
"x": "Louisville",
"y": 123
},
{
"x": "Memphis",
"y": 108
},
{
"x": "Miami",
"y": 135
},
{
"x": "Milwaukee",
"y": 127
},
{
"x": "Minneapolis",
"y": 117
},
{
"x": "Nashville",
"y": 119
},
{
"x": "New Orleans",
"y": 115
},
{
"x": "New York",
"y": 122
},
{
"x": "Oklahoma City",
"y": 84
},
{
"x": "Orlando",
"y": 117
},
{
"x": "Philadelphia",
"y": 118
},
{
"x": "Phoenix",
"y": 30
},
{
"x": "Pittsburgh",
"y": 151
},
{
"x": "Portland",
"y": 164
},
{
"x": "Providence",
"y": 125
},
{
"x": "Raleigh",
"y": 100
},
{
"x": "Richmond",
"y": 114
},
{
"x": "Riverside",
"y": 30
},
{
"x": "Rochester",
"y": 167
},
{
"x": "Sacramento",
"y": 60
},
{
"x": "Salt Lake City",
"y": 96
},
{
"x": "San Antonio",
"y": 83
},
{
"x": "San Diego",
"y": 42
},
{
"x": "San Francisco",
"y": 68
},
{
"x": "San Jose",
"y": 62
},
{
"x": "Seattle",
"y": 149
},
{
"x": "St. Louis",
"y": 113
},
{
"x": "Tampa",
"y": 105
},
{
"x": "Virginia Beach",
"y": 117
},
{
"x": "Washington",
"y": 114
}
],
"selectionRanges": [
{
"sourceRowId1": 292,
"sourceRowId2": 908,
"sourceColumnId1": 988,
"sourceColumnId2": 988
}
]
},
{
"title": "Inches",
"titleInfo": {
"type": "TEXT_NUMBER"
},
"seriesType": "COLUMN",
"tooltips": {
"labelType": "X-SERIES-Y"
},
"color": "#EA352E",
"axisLocationX": "BOTTOM",
"axisLocationY": "LEFT",
"yColumnInfo": {
"type": "TEXT_NUMBER"
},
"xColumnInfo": {
"type": "TEXT_NUMBER"
},
"seriesData": [
{
"y": 49.7
},
{
"x": "Austin",
"y": 34.2
},
{
"x": "Baltimore",
"y": 41.9
},
{
"x": "Birmingham",
"y": 53.7
},
{
"x": "Boston",
"y": 43.8
},
{
"x": "Buffalo",
"y": 40.5
},
{
"x": "Charlotte",
"y": 41.6
},
{
"x": "Chicago",
"y": 36.9
},
{
"x": "Cincinnati",
"y": 41.9
},
{
"x": "Cleveland",
"y": 39.1
},
{
"x": "Columbus",
"y": 39.3
},
{
"x": "Dallas",
"y": 37.6
},
{
"x": "Denver",
"y": 15.6
},
{
"x": "Detroit",
"y": 33.5
},
{
"x": "Hartford",
"y": 45.9
},
{
"x": "Houston",
"y": 49.8
},
{
"x": "Indianapolis",
"y": 42.4
},
{
"x": "Jacksonville",
"y": 52.4
},
{
"x": "Kansas City",
"y": 39.1
},
{
"x": "Las Vegas",
"y": 4.2
},
{
"x": "Los Angeles",
"y": 12.8
},
{
"x": "Louisville",
"y": 44.9
},
{
"x": "Memphis",
"y": 53.7
},
{
"x": "Miami",
"y": 61.9
},
{
"x": "Milwaukee",
"y": 34.8
},
{
"x": "Minneapolis",
"y": 30.6
},
{
"x": "Nashville",
"y": 47.3
},
{
"x": "New Orleans",
"y": 62.7
},
{
"x": "New York",
"y": 49.9
},
{
"x": "Oklahoma City",
"y": 36.5
},
{
"x": "Orlando",
"y": 50.7
},
{
"x": "Philadelphia",
"y": 41.5
},
{
"x": "Phoenix",
"y": 8.2
},
{
"x": "Pittsburgh",
"y": 38.2
},
{
"x": "Portland",
"y": 43.5
},
{
"x": "Providence",
"y": 47.2
},
{
"x": "Raleigh",
"y": 46
},
{
"x": "Richmond",
"y": 43.6
},
{
"x": "Riverside",
"y": 10.3
},
{
"x": "Rochester",
"y": 34.3
},
{
"x": "Sacramento",
"y": 18.5
},
{
"x": "Salt Lake City",
"y": 16.1
},
{
"x": "San Antonio",
"y": 32.3
},
{
"x": "San Diego",
"y": 10.3
},
{
"x": "San Francisco",
"y": 20.7
},
{
"x": "San Jose",
"y": 15.8
},
{
"x": "Seattle",
"y": 37.7
},
{
"x": "St. Louis",
"y": 41
},
{
"x": "Tampa",
"y": 46.3
},
{
"x": "Virginia Beach",
"y": 46.5
},
{
"x": "Washington",
"y": 39.7
}
],
"selectionRanges": [
{
"sourceRowId1": 292,
"sourceRowId2": 908,
"sourceColumnId1": 740,
"sourceColumnId2": 740
}
]
}
],
"columns": [
"axes": [
{
"id": 788,
"index": 2,
"title": "Population (July 1, 2013)",
"type": "TEXT_NUMBER",
"validation": false,
"width": 150
"location": "LEFT",
"includeZero": true
},
{
"location": "BOTTOM"
}
],
"gridID": 10624332
"legend": {
"location": "RIGHT"
},
"sheetId": 524,
"selectionRanges": [
{
"sourceRowId1": 292,
"sourceRowId2": 908,
"sourceColumnId1": 612,
"sourceColumnId2": 740
}
]
},
"xPosition": 0,
"yPosition": 11,
"width": 4,
"height": 6,
"title": "Annual Averages for Total Precipitation By City",
"showTitleIcon": false,
"showTitle": true,
"titleFormat": ",,1,,,,,,,3,,,,,,1,",
"version": 1
},
{
"id": 932,
"type": "IMAGE",
"contents": {
"type": "IMAGE",
"hyperlink": {
"url": "http://www.smartsheet.com",
"interactionType": "WEB"
},
"privateId": "_kpnN9Q",
"height": 48,
"width": 197,
"fileName": "smartsheet-logo-blue-197x48.png",
"format": ",7,1,,,,2,2,1,3,,,,,,1,"
},
"xPosition": 4,
"yPosition": 5,
"yPosition": 1,
"width": 1,
"height": 2,
"title": "Starbucks Stores By State",
"showTitleIcon": true,
"height": 4,
"showTitleIcon": false,
"showTitle": false,
"version": 1
},
{
"id": 636,
"type": "WEBCONTENT",
"contents": {
"type": "WidgetWebContent",
"url": "https://www.youtube.com/"
},
"xPosition": 0,
"yPosition": 17,
"width": 4,
"height": 6,
"showTitleIcon": false,
"showTitle": true,
"titleFormat": ",,1,,,,,,,3,,,,,,1",
"titleFormat": ",,1,,,,,,,3,,,,,,1,",
"version": 1
}
]
],
"createdAt": "2016-08-14T23:45:06Z",
"modifiedAt": "2019-07-12T22:25:42Z"
},

@@ -311,0 +828,0 @@ "headers": {

@@ -32,14 +32,16 @@ {

"backgroundColor": "#E2E2E2",
"permalink": "https://app.smartsheet.com/dashboards/PP1",
"columnCount": 6,
"widgets": [
{
"id": 556,
"id": 532,
"type": "SHORTCUTLIST",
"contents": {
"type": "SHORTCUT",
"shortcutData": [
{
"label": "Starbucks Stores By State",
"labelFormat": ",2,,,,,1,,1,,,,,,,",
"labelFormat": ",2,,,,,1,,1,,,,,,,,",
"hyperlink": {
"url": "https://app.smartsheet.com/b/home",
"url": "https://app.smartsheet.com/sheets/r21",
"sheetId": 500

@@ -58,9 +60,14 @@ },

"showTitle": true,
"titleFormat": ",,1,,,,,,,3,,,,,,1",
"titleFormat": ",,1,,,,,,,3,,,,,,1,",
"version": 1
},
{
"id": 500,
"id": 28,
"type": "SHEETSUMMARY",
"contents": {
"type": "METRIC",
"hyperlink": {
"url": "http://www.seattle.gov/",
"interactionType": "WEB"
},
"cellData": [

@@ -70,7 +77,8 @@ {

"label": "Millimetres",
"labelFormat": ",2,,,,,,,1,,,,,,,1",
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1",
"labelFormat": ",2,,,,,,,1,,,,,,,1,",
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1,",
"order": 4,
"cell": {
"columnId": 236,
"rowId": 284,
"value": 958,

@@ -80,2 +88,3 @@ "objectValue": 958,

},
"dataSource": "CELL",
"objectValue": 958

@@ -86,7 +95,8 @@ },

"label": "State",
"labelFormat": ",2,,,,,,,1,,,,,,,1",
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1",
"labelFormat": ",2,,,,,,,1,,,,,,,1,",
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1,",
"order": 1,
"cell": {
"columnId": 492,
"rowId": 284,
"value": "Washington",

@@ -96,2 +106,3 @@ "objectValue": "Washington",

},
"dataSource": "CELL",
"objectValue": "Washington"

@@ -102,7 +113,8 @@ },

"label": "City",
"labelFormat": ",2,,,,,,,1,,,,,,,1",
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1",
"labelFormat": ",2,,,,,,,1,,,,,,,1,",
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1,",
"order": 0,
"cell": {
"columnId": 612,
"rowId": 284,
"value": "Seattle",

@@ -112,2 +124,3 @@ "objectValue": "Seattle",

},
"dataSource": "CELL",
"objectValue": "Seattle"

@@ -118,7 +131,8 @@ },

"label": "Inches",
"labelFormat": ",2,,,,,,,1,,,,,,,1",
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1",
"labelFormat": ",2,,,,,,,1,,,,,,,1,",
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1,",
"order": 3,
"cell": {
"columnId": 740,
"rowId": 284,
"value": 37.7,

@@ -128,2 +142,3 @@ "objectValue": 37.7,

},
"dataSource": "CELL",
"objectValue": 37.7

@@ -134,7 +149,8 @@ },

"label": "Days",
"labelFormat": ",2,,,,,,,1,,,,,,,1",
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1",
"labelFormat": ",2,,,,,,,1,,,,,,,1,",
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1,",
"order": 2,
"cell": {
"columnId": 988,
"rowId": 284,
"value": 149,

@@ -144,2 +160,3 @@ "objectValue": 149,

},
"dataSource": "CELL",
"objectValue": 149

@@ -151,2 +168,3 @@ }

"id": 612,
"version": 0,
"index": 0,

@@ -161,2 +179,3 @@ "title": "City",

"id": 492,
"version": 0,
"index": 1,

@@ -170,2 +189,3 @@ "title": "State",

"id": 988,
"version": 0,
"index": 2,

@@ -179,2 +199,3 @@ "title": "Days",

"id": 740,
"version": 0,
"index": 3,

@@ -188,2 +209,3 @@ "title": "Inches",

"id": 236,
"version": 0,
"index": 4,

@@ -196,3 +218,3 @@ "title": "Millimetres",

],
"gridID": 10624640
"sheetId": 524
},

@@ -206,9 +228,10 @@ "xPosition": 1,

"showTitle": true,
"titleFormat": ",,1,,,,,,,3,,,,,,1",
"titleFormat": ",,1,,,,,,,3,,,,,,1,",
"version": 1
},
{
"id": 5371172654212996,
"id": 20,
"type": "RICHTEXT",
"contents": {
"type": "RICHTEXT",
"htmlContent": "<p>This is a&nbsp;<span class=\"clsDbFt\" style=\"font-family:'arial';font-size:10pt;font-weight:bold;font-style:normal;text-decoration:none;color:rgb( 0 , 0 , 0 );background-color:rgb( 255 , 255 , 255 )\">rich</span><span class=\"clsDbFt\" style=\"font-family:'arial';font-size:10pt;font-weight:normal;font-style:italic;text-decoration:none;color:rgb( 0 , 0 , 0 );background-color:rgb( 255 , 255 , 255 )\">text&nbsp;</span><span class=\"clsDbFt\" style=\"font-family:'arial';font-size:10pt;font-weight:normal;font-style:normal;text-decoration:none;color:rgb( 0 , 0 , 0 );background-color:rgb( 255 , 255 , 255 )\">test</span></p>"

@@ -225,24 +248,13 @@ },

{
"id": 748,
"type": "IMAGE",
"contents": {
"privateId": "TCA",
"height": 18,
"width": 18,
"fileName": "info_tip_16x16.png",
"format": ",7,1,,,,2,2,1,3,,,,,,1"
},
"xPosition": 4,
"yPosition": 1,
"width": 1,
"height": 4,
"showTitleIcon": false,
"showTitle": false,
"version": 1
},
{
"id": 244,
"id": 516,
"type": "GRIDGANTT",
"contents": {
"htmlContent": "<style type=\"text/css\">"
"type": "GRIDGANTT",
"hyperlink": {
"url": "https://app.smartsheet.com/reports/J81",
"reportId": 876,
"interactionType": "SOURCE_SHEET"
},
"htmlContent": "<style type=\"text/css\">",
"reportId": 876
},

@@ -258,7 +270,8 @@ "xPosition": 0,

{
"id": 124,
"id": 268,
"type": "TITLE",
"contents": {
"htmlContent": "<p style=\"text-align:center\"><span class=\"clsDbFt\">This is my title</span></p>",
"backgroundColor": "#F7F7F7"
"type": "RICHTEXT",
"htmlContent": "<p style=\"text-align:center\"><span class=\"clsDbFt\" style=\"font-family:&#39;arial&#39;;font-size:20pt;font-weight:bold;font-style:normal;text-decoration:none;color:rgb( 0 , 0 , 0 )\"></span><span class=\"clsDbFt\">This is my title</span></p>",
"backgroundColor": "#D0AF8F"
},

@@ -274,47 +287,551 @@ "xPosition": 0,

{
"id": 620,
"type": "SHEETSUMMARY",
"id": 764,
"type": "CHART",
"contents": {
"type": "CHART",
"hyperlink": {
"url": "http://www.somesite.com"
"url": "https://app.smartsheet.com/sheets/9J1",
"sheetId": 660,
"interactionType": "SMARTSHEET_ITEM"
},
"cellData": [
"series": [
{
"columnId": 788,
"label": "Population (July 1, 2013)",
"labelFormat": ",2,,,,,,,1,,,,,,,1",
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1",
"order": 0,
"cell": {
"columnId": 788,
"value": 6971406,
"objectValue": 6971406,
"displayValue": "6971406"
"title": "Days",
"titleInfo": {
"type": "TEXT_NUMBER"
},
"objectValue": 6971406
"seriesType": "COLUMN",
"tooltips": {
"labelType": "X-SERIES-Y"
},
"color": "#1061C3",
"axisLocationX": "BOTTOM",
"axisLocationY": "LEFT",
"yColumnInfo": {
"type": "TEXT_NUMBER"
},
"xColumnInfo": {
"type": "TEXT_NUMBER"
},
"seriesData": [
{
"y": 113
},
{
"x": "Austin",
"y": 88
},
{
"x": "Baltimore",
"y": 116
},
{
"x": "Birmingham",
"y": 117
},
{
"x": "Boston",
"y": 126
},
{
"x": "Buffalo",
"y": 167
},
{
"x": "Charlotte",
"y": 110
},
{
"x": "Chicago",
"y": 124
},
{
"x": "Cincinnati",
"y": 137
},
{
"x": "Cleveland",
"y": 155
},
{
"x": "Columbus",
"y": 139
},
{
"x": "Dallas",
"y": 81
},
{
"x": "Denver",
"y": 87
},
{
"x": "Detroit",
"y": 135
},
{
"x": "Hartford",
"y": 130
},
{
"x": "Houston",
"y": 104
},
{
"x": "Indianapolis",
"y": 129
},
{
"x": "Jacksonville",
"y": 114
},
{
"x": "Kansas City",
"y": 91
},
{
"x": "Las Vegas",
"y": 27
},
{
"x": "Los Angeles",
"y": 36
},
{
"x": "Louisville",
"y": 123
},
{
"x": "Memphis",
"y": 108
},
{
"x": "Miami",
"y": 135
},
{
"x": "Milwaukee",
"y": 127
},
{
"x": "Minneapolis",
"y": 117
},
{
"x": "Nashville",
"y": 119
},
{
"x": "New Orleans",
"y": 115
},
{
"x": "New York",
"y": 122
},
{
"x": "Oklahoma City",
"y": 84
},
{
"x": "Orlando",
"y": 117
},
{
"x": "Philadelphia",
"y": 118
},
{
"x": "Phoenix",
"y": 30
},
{
"x": "Pittsburgh",
"y": 151
},
{
"x": "Portland",
"y": 164
},
{
"x": "Providence",
"y": 125
},
{
"x": "Raleigh",
"y": 100
},
{
"x": "Richmond",
"y": 114
},
{
"x": "Riverside",
"y": 30
},
{
"x": "Rochester",
"y": 167
},
{
"x": "Sacramento",
"y": 60
},
{
"x": "Salt Lake City",
"y": 96
},
{
"x": "San Antonio",
"y": 83
},
{
"x": "San Diego",
"y": 42
},
{
"x": "San Francisco",
"y": 68
},
{
"x": "San Jose",
"y": 62
},
{
"x": "Seattle",
"y": 149
},
{
"x": "St. Louis",
"y": 113
},
{
"x": "Tampa",
"y": 105
},
{
"x": "Virginia Beach",
"y": 117
},
{
"x": "Washington",
"y": 114
}
],
"selectionRanges": [
{
"sourceRowId1": 292,
"sourceRowId2": 908,
"sourceColumnId1": 988,
"sourceColumnId2": 988
}
]
},
{
"title": "Inches",
"titleInfo": {
"type": "TEXT_NUMBER"
},
"seriesType": "COLUMN",
"tooltips": {
"labelType": "X-SERIES-Y"
},
"color": "#EA352E",
"axisLocationX": "BOTTOM",
"axisLocationY": "LEFT",
"yColumnInfo": {
"type": "TEXT_NUMBER"
},
"xColumnInfo": {
"type": "TEXT_NUMBER"
},
"seriesData": [
{
"y": 49.7
},
{
"x": "Austin",
"y": 34.2
},
{
"x": "Baltimore",
"y": 41.9
},
{
"x": "Birmingham",
"y": 53.7
},
{
"x": "Boston",
"y": 43.8
},
{
"x": "Buffalo",
"y": 40.5
},
{
"x": "Charlotte",
"y": 41.6
},
{
"x": "Chicago",
"y": 36.9
},
{
"x": "Cincinnati",
"y": 41.9
},
{
"x": "Cleveland",
"y": 39.1
},
{
"x": "Columbus",
"y": 39.3
},
{
"x": "Dallas",
"y": 37.6
},
{
"x": "Denver",
"y": 15.6
},
{
"x": "Detroit",
"y": 33.5
},
{
"x": "Hartford",
"y": 45.9
},
{
"x": "Houston",
"y": 49.8
},
{
"x": "Indianapolis",
"y": 42.4
},
{
"x": "Jacksonville",
"y": 52.4
},
{
"x": "Kansas City",
"y": 39.1
},
{
"x": "Las Vegas",
"y": 4.2
},
{
"x": "Los Angeles",
"y": 12.8
},
{
"x": "Louisville",
"y": 44.9
},
{
"x": "Memphis",
"y": 53.7
},
{
"x": "Miami",
"y": 61.9
},
{
"x": "Milwaukee",
"y": 34.8
},
{
"x": "Minneapolis",
"y": 30.6
},
{
"x": "Nashville",
"y": 47.3
},
{
"x": "New Orleans",
"y": 62.7
},
{
"x": "New York",
"y": 49.9
},
{
"x": "Oklahoma City",
"y": 36.5
},
{
"x": "Orlando",
"y": 50.7
},
{
"x": "Philadelphia",
"y": 41.5
},
{
"x": "Phoenix",
"y": 8.2
},
{
"x": "Pittsburgh",
"y": 38.2
},
{
"x": "Portland",
"y": 43.5
},
{
"x": "Providence",
"y": 47.2
},
{
"x": "Raleigh",
"y": 46
},
{
"x": "Richmond",
"y": 43.6
},
{
"x": "Riverside",
"y": 10.3
},
{
"x": "Rochester",
"y": 34.3
},
{
"x": "Sacramento",
"y": 18.5
},
{
"x": "Salt Lake City",
"y": 16.1
},
{
"x": "San Antonio",
"y": 32.3
},
{
"x": "San Diego",
"y": 10.3
},
{
"x": "San Francisco",
"y": 20.7
},
{
"x": "San Jose",
"y": 15.8
},
{
"x": "Seattle",
"y": 37.7
},
{
"x": "St. Louis",
"y": 41
},
{
"x": "Tampa",
"y": 46.3
},
{
"x": "Virginia Beach",
"y": 46.5
},
{
"x": "Washington",
"y": 39.7
}
],
"selectionRanges": [
{
"sourceRowId1": 292,
"sourceRowId2": 908,
"sourceColumnId1": 740,
"sourceColumnId2": 740
}
]
}
],
"columns": [
"axes": [
{
"id": 788,
"index": 2,
"title": "Population (July 1, 2013)",
"type": "TEXT_NUMBER",
"validation": false,
"width": 150
"location": "LEFT",
"includeZero": true
},
{
"location": "BOTTOM"
}
],
"gridID": 10624332
"legend": {
"location": "RIGHT"
},
"sheetId": 524,
"selectionRanges": [
{
"sourceRowId1": 292,
"sourceRowId2": 908,
"sourceColumnId1": 612,
"sourceColumnId2": 740
}
]
},
"xPosition": 0,
"yPosition": 11,
"width": 4,
"height": 6,
"title": "Annual Averages for Total Precipitation By City",
"showTitleIcon": false,
"showTitle": true,
"titleFormat": ",,1,,,,,,,3,,,,,,1,",
"version": 1
},
{
"id": 644,
"type": "IMAGE",
"contents": {
"type": "IMAGE",
"hyperlink": {
"url": "http://www.smartsheet.com",
"interactionType": "WEB"
},
"privateId": "Jppz",
"height": 48,
"width": 197,
"fileName": "smartsheet-logo-blue-197x48.png",
"format": ",7,1,,,,2,2,1,3,,,,,,1,"
},
"xPosition": 4,
"yPosition": 5,
"yPosition": 1,
"width": 1,
"height": 2,
"title": "Starbucks Stores By State",
"showTitleIcon": true,
"height": 4,
"showTitleIcon": false,
"showTitle": false,
"version": 1
},
{
"id": 140,
"type": "WEBCONTENT",
"contents": {
"type": "WidgetWebContent",
"url": "https://www.youtube.com/"
},
"xPosition": 0,
"yPosition": 17,
"width": 4,
"height": 6,
"showTitleIcon": false,
"showTitle": true,
"titleFormat": ",,1,,,,,,,3,,,,,,1",
"titleFormat": ",,1,,,,,,,3,,,,,,1,",
"version": 1
}
]
],
"createdAt": "2019-08-07T20:12:02Z",
"modifiedAt": "2019-08-07T20:12:02Z"
}

@@ -321,0 +838,0 @@ },

Sorry, the diff of this file is not supported yet

Sorry, the diff of this file is too big to display

Sorry, the diff of this file is too big to display

SocketSocket SOC 2 Logo

Product

  • Package Alerts
  • Integrations
  • Docs
  • Pricing
  • FAQ
  • Roadmap
  • Changelog

Packages

npm

Stay in touch

Get open source security insights delivered straight into your inbox.


  • Terms
  • Privacy
  • Security

Made with ⚡️ by Socket Inc