1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
106
107
108
109
110

var body = {
  'app': kintone.app.getId(),
  'reports': {
    'Graph1 (Default Settings)': {
      'chartType': 'BAR',
      'chartMode': 'NORMAL',
      'name': 'Graph1 (Default Settings)',
      'index': '0',
      'groups': [{
        'code': 'Created_by'
      }],
      'aggregations': [{
        'type': 'COUNT'
      }],
      'filterCond': '',
      'sorts': [{
        'by': 'TOTAL',
        'order': 'DESC'
      }],
      'periodicReport': null
    },
    'Graph2 (Table)': {
      'chartType': 'TABLE',
      'name': 'Graph2 (Table)',
      'index': '1',
      'groups': [{
        'code': 'Radio_button'
      },
      {
        'code': 'Created_datetime',
        'per': 'YEAR'
      },
      {
        'code': 'Time',
        'per': 'MINUTE'
      }
      ],
      'aggregations': [{
        'type': 'COUNT'
      },
      {
        'type': 'SUM',
        'code': 'Number'
      },
      {
        'type': 'AVERAGE',
        'code': 'Calculated'
      },
      {
        'type': 'MAX',
        'code': 'Created_datetime'
      },
      {
        'type': 'MIN',
        'code': 'Time'
      }
      ],
      'filterCond': 'Record_number = \'1\' and Rich_text like \'aaa\'',
      'sorts': [{
        'by': 'TOTAL',
        'order': 'DESC'
      },
      {
        'by': 'GROUP1',
        'order': 'ASC'
      },
      {
        'by': 'GROUP2',
        'order': 'DESC'
      }
      ],
      'periodicReport': null
    },
    'Graph3 (Periodic report ON)': {
      'chartType': 'BAR',
      'chartMode': 'NORMAL',
      'name': 'Graph3 (Periodic report ON)',
      'index': '2',
      'groups': [{
        'code': 'Radio_button'
      }],
      'aggregations': [{
        'type': 'COUNT'
      }],
      'filterCond': '',
      'sorts': [{
        'by': 'TOTAL',
        'order': 'DESC'
      }],
      'periodicReport': {
        'active': true,
        'period': {
          'every': 'QUARTER',
          'pattern': 'JAN_APR_JUL_OCT',
          'dayOfMonth': 'END_OF_MONTH',
          'time': '23:30'
        }
      }
    }
  },
  'revision': '2'
};

kintone.api(kintone.api.url('/k/v1/preview/app/reports.json', true), 'PUT', body, function(resp) {
  // success
  console.log(resp);
}, function(error) {
  // error
  console.log(error);
});

  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120

var body = {
  'app': kintone.app.getId(),
  'reports': {
    'Graph1 (Default Settings)': {
      'chartType': 'BAR',
      'chartMode': 'NORMAL',
      'name': 'Graph1 (Default Settings)',
      'index': '0',
      'groups': [{
        'code': 'Created_by'
      }],
      'aggregations': [{
        'type': 'COUNT'
      }],
      'filterCond': '',
      'sorts': [{
        'by': 'TOTAL',
        'order': 'DESC'
      }],
      'periodicReport': null
    },
    'Graph2 (Table)': {
      'chartType': 'TABLE',
      'name': 'Graph2 (Table)',
      'index': '1',
      'groups': [{
        'code': 'Radio_button'
      },
      {
        'code': 'Created_datetime',
        'per': 'YEAR'
      },
      {
        'code': 'Time',
        'per': 'MINUTE'
      }
      ],
      'aggregations': [{
        'type': 'COUNT'
      },
      {
        'type': 'SUM',
        'code': 'Number'
      },
      {
        'type': 'AVERAGE',
        'code': 'Calculated'
      },
      {
        'type': 'MAX',
        'code': 'Created_datetime'
      },
      {
        'type': 'MIN',
        'code': 'Time'
      }
      ],
      'filterCond': 'Record_number = \'1\' and Rich_text like \'aaa\'',
      'sorts': [{
        'by': 'TOTAL',
        'order': 'DESC'
      },
      {
        'by': 'GROUP1',
        'order': 'ASC'
      },
      {
        'by': 'GROUP2',
        'order': 'DESC'
      }
      ],
      'periodicReport': null
    },
    'Graph3 (Periodic report ON)': {
      'chartType': 'BAR',
      'chartMode': 'NORMAL',
      'name': 'Graph3 (Periodic report ON)',
      'index': '2',
      'groups': [{
        'code': 'Radio_button'
      }],
      'aggregations': [{
        'type': 'COUNT'
      }],
      'filterCond': '',
      'sorts': [{
        'by': 'TOTAL',
        'order': 'DESC'
      }],
      'periodicReport': {
        'active': true,
        'period': {
          'every': 'QUARTER',
          'pattern': 'JAN_APR_JUL_OCT',
          'dayOfMonth': 'END_OF_MONTH',
          'time': '23:30'
        }
      }
    }
  },
  'revision': '2',
  // CSRF TOKEN: used for all APIs that have an HTTP method of POST, PUT, and DELETE on Kintone.
  '__REQUEST_TOKEN__': kintone.getRequestToken()
};

var url = 'https://{subdomain}.kintone.com/k/v1/preview/app/reports.json';
var xhr = new XMLHttpRequest();
xhr.open('PUT', url);
xhr.setRequestHeader('X-Requested-With', 'XMLHttpRequest');
xhr.setRequestHeader('Content-Type', 'application/json');
xhr.onload = function() {
  if (xhr.status === 200) {
    // success
    console.log(JSON.parse(xhr.responseText));
  } else {
    // error
    console.log(JSON.parse(xhr.responseText));
  }
};
xhr.send(JSON.stringify(body));

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14

{
  "revision": "2",
  "reports": {
    "Graph1 (Default Settings)": {
      "id": "7319"
    },
    "Graph2 (Table)": {
      "id": "7321"
    },
    "Graph3 (Periodic report ON)": {
      "id": "7323"
    }
  }
}