Create a new report using a POST request.
/services/data/v39.0/analytics/reports
To create a report, you only have to specify reportMetadata with a name and a reportType to create a new report. Other properties are optional.
1{
2 "reportMetadata": {
3 "name":"NewReport",
4 "reportType": {
5 "type" : "Opportunity"
6 }
7 }
8}The response includes the new report’s reportExtendedMetadata, reportMetadata, and reportTypeMetadata.
1{
2 "reportExtendedMetadata" : {
3 "aggregateColumnInfo" : {
4 "RowCount" : {
5 "dataType" : "int",
6 "label" : "Record Count"
7 }
8 },
9 "detailColumnInfo" : {
10 "ROLLUP_DESCRIPTION" : {
11 "dataType" : "string",
12 "label" : "Owner Role"
13 },
14 "FULL_NAME" : {
15 "dataType" : "string",
16 "label" : "Opportunity Owner"
17 },
18 "ACCOUNT_NAME" : {
19 "dataType" : "string",
20 "label" : "Account Name"
21 },
22 "OPPORTUNITY_NAME" : {
23 "dataType" : "string",
24 "label" : "Opportunity Name"
25 },
26 "STAGE_NAME" : {
27 "dataType" : "picklist",
28 "label" : "Stage"
29 },
30 "FISCAL_QUARTER" : {
31 "dataType" : "string",
32 "label" : "Fiscal Period"
33 },
34 "AMOUNT" : {
35 "dataType" : "currency",
36 "label" : "Amount"
37 },
38 "PROBABILITY" : {
39 "dataType" : "percent",
40 "label" : "Probability (%)"
41 },
42 "AGE" : {
43 "dataType" : "int",
44 "label" : "Age"
45 },
46 "CLOSE_DATE" : {
47 "dataType" : "date",
48 "label" : "Close Date"
49 },
50 "CREATED_DATE" : {
51 "dataType" : "datetime",
52 "label" : "Created Date"
53 },
54 "NEXT_STEP" : {
55 "dataType" : "string",
56 "label" : "Next Step"
57 },
58 "LEAD_SOURCE" : {
59 "dataType" : "picklist",
60 "label" : "Lead Source"
61 },
62 "TYPE" : {
63 "dataType" : "picklist",
64 "label" : "Type"
65 }
66 },
67 "groupingColumnInfo" : { }
68 },
69 "reportMetadata" : {
70 "aggregates" : [ "RowCount" ],
71 "chart" : null,
72 "crossFilters" : [ ],
73 "currency" : null,
74 "description" : null,
75 "detailColumns" : [ "ROLLUP_DESCRIPTION", "FULL_NAME", "ACCOUNT_NAME", "OPPORTUNITY_NAME", "STAGE_NAME", "FISCAL_QUARTER", "AMOUNT", "PROBABILITY", "AGE", "CLOSE_DATE", "CREATED_DATE", "NEXT_STEP", "LEAD_SOURCE", "TYPE" ],
76 "developerName" : "DocTest2_mG",
77 "division" : null,
78 "folderId" : "005R0000000Kg8cIAC",
79 "groupingsAcross" : [ ],
80 "groupingsDown" : [ ],
81 "hasDetailRows" : true,
82 "hasRecordCount" : true,
83 "historicalSnapshotDates" : [ ],
84 "id" : "00OR0000000PYkiMAG",
85 "name" : "DocTest2",
86 "reportBooleanFilter" : null,
87 "reportFilters" : [ ],
88 "reportFormat" : "TABULAR",
89 "reportType" : {
90 "label" : "Opportunities",
91 "type" : "Opportunity"
92 },
93 "scope" : "organization",
94 "showGrandTotal" : true,
95 "showSubtotals" : true,
96 "sortBy" : [ ],
97 "standardDateFilter" : {
98 "column" : "CLOSE_DATE",
99 "durationValue" : "THIS_FISCAL_QUARTER",
100 "endDate" : "2016-12-31",
101 "startDate" : "2016-10-01"
102 },
103 "standardFilters" : [ {
104 "name" : "open",
105 "value" : "all"
106 }, {
107 "name" : "probability",
108 "value" : ">0"
109 } ],
110 "supportsRoleHierarchy" : true,
111 "userOrHierarchyFilterId" : null
112 },
113 "reportTypeMetadata" : {
114 "categories" : [ {
115 "columns" : {
116 "CREATED" : {
117 "dataType" : "string",
118 "filterValues" : [ ],
119 "filterable" : true,
120 "label" : "Created By"
121 },
122 "CREATED_ALIAS" : {
123 "dataType" : "string",
124 "filterValues" : [ ],
125 "filterable" : true,
126 "label" : "Created Alias"
127 },
128 "LAST_UPDATE_BY" : {
129 "dataType" : "string",
130 "filterValues" : [ ],
131 "filterable" : true,
132 "label" : "Last Modified By"
133 },
134 "LAST_UPDATE_BY_ALIAS" : {
135 "dataType" : "string",
136 "filterValues" : [ ],
137 "filterable" : true,
138 "label" : "Last Modified Alias"
139 },
140 "OPPORTUNITY_NAME" : {
141 "dataType" : "string",
142 "filterValues" : [ ],
143 "filterable" : true,
144 "label" : "Opportunity Name"
145 },
146 "TYPE" : {
147 "dataType" : "picklist",
148 "filterValues" : [ {
149 "label" : "Existing Business",
150 "name" : "Existing Business"
151 }, {
152 "label" : "New Business",
153 "name" : "New Business"
154 } ],
155 "filterable" : true,
156 "label" : "Type"
157 },
158 "LEAD_SOURCE" : {
159 "dataType" : "picklist",
160 "filterValues" : [ {
161 "label" : "Advertisement",
162 "name" : "Advertisement"
163 }, {
164 "label" : "Employee Referral",
165 "name" : "Employee Referral"
166 }, {
167 "label" : "External Referral",
168 "name" : "External Referral"
169 }, {
170 "label" : "Partner",
171 "name" : "Partner"
172 }, {
173 "label" : "Public Relations",
174 "name" : "Public Relations"
175 }, {
176 "label" : "Seminar - Internal",
177 "name" : "Seminar - Internal"
178 }, {
179 "label" : "Seminar - Partner",
180 "name" : "Seminar - Partner"
181 }, {
182 "label" : "Trade Show",
183 "name" : "Trade Show"
184 }, {
185 "label" : "Web",
186 "name" : "Web"
187 }, {
188 "label" : "Word of mouth",
189 "name" : "Word of mouth"
190 }, {
191 "label" : "Other",
192 "name" : "Other"
193 } ],
194 "filterable" : true,
195 "label" : "Lead Source"
196 },
197 "PARTNER_NAME" : {
198 "dataType" : "string",
199 "filterValues" : [ ],
200 "filterable" : true,
201 "label" : "Primary Partner"
202 },
203 "AMOUNT" : {
204 "dataType" : "currency",
205 "filterValues" : [ ],
206 "filterable" : true,
207 "label" : "Amount"
208 },
209 "CLOSED" : {
210 "dataType" : "boolean",
211 "filterValues" : [ {
212 "label" : "True",
213 "name" : "True"
214 }, {
215 "label" : "False",
216 "name" : "False"
217 } ],
218 "filterable" : true,
219 "label" : "Closed"
220 },
221 "WON" : {
222 "dataType" : "boolean",
223 "filterValues" : [ {
224 "label" : "True",
225 "name" : "True"
226 }, {
227 "label" : "False",
228 "name" : "False"
229 } ],
230 "filterable" : true,
231 "label" : "Won"
232 },
233 "CLOSE_DATE" : {
234 "dataType" : "date",
235 "filterValues" : [ ],
236 "filterable" : true,
237 "label" : "Close Date"
238 },
239 "CLOSE_DATE2" : {
240 "dataType" : "date",
241 "filterValues" : [ ],
242 "filterable" : true,
243 "label" : "Close Date (2)"
244 },
245 "CLOSE_MONTH" : {
246 "dataType" : "date",
247 "filterValues" : [ ],
248 "filterable" : true,
249 "label" : "Close Month"
250 },
251 "LAST_STAGE_CHANGE_DATE" : {
252 "dataType" : "datetime",
253 "filterValues" : [ ],
254 "filterable" : true,
255 "label" : "Last Stage Change Date"
256 },
257 "NEXT_STEP" : {
258 "dataType" : "string",
259 "filterValues" : [ ],
260 "filterable" : true,
261 "label" : "Next Step"
262 },
263 "STAGE_NAME" : {
264 "dataType" : "picklist",
265 "filterValues" : [ {
266 "label" : "Prospecting",
267 "name" : "Prospecting"
268 }, {
269 "label" : "Qualification",
270 "name" : "Qualification"
271 }, {
272 "label" : "Needs Analysis",
273 "name" : "Needs Analysis"
274 }, {
275 "label" : "Value Proposition",
276 "name" : "Value Proposition"
277 }, {
278 "label" : "Id. Decision Makers",
279 "name" : "Id. Decision Makers"
280 }, {
281 "label" : "Perception Analysis",
282 "name" : "Perception Analysis"
283 }, {
284 "label" : "Proposal/Price Quote",
285 "name" : "Proposal/Price Quote"
286 }, {
287 "label" : "Negotiation/Review",
288 "name" : "Negotiation/Review"
289 }, {
290 "label" : "Closed Won",
291 "name" : "Closed Won"
292 }, {
293 "label" : "Closed Lost",
294 "name" : "Closed Lost"
295 } ],
296 "filterable" : true,
297 "label" : "Stage"
298 },
299 "PROBABILITY" : {
300 "dataType" : "percent",
301 "filterValues" : [ ],
302 "filterable" : true,
303 "label" : "Probability (%)"
304 },
305 "FISCAL_QUARTER" : {
306 "dataType" : "string",
307 "filterValues" : [ ],
308 "filterable" : true,
309 "label" : "Fiscal Period"
310 },
311 "FISCAL_YEAR" : {
312 "dataType" : "int",
313 "filterValues" : [ ],
314 "filterable" : true,
315 "label" : "Fiscal Year"
316 },
317 "AGE" : {
318 "dataType" : "int",
319 "filterValues" : [ ],
320 "filterable" : true,
321 "label" : "Age"
322 },
323 "STAGE_DURATION" : {
324 "dataType" : "int",
325 "filterValues" : [ ],
326 "filterable" : true,
327 "label" : "Stage Duration"
328 },
329 "FORECAST_CATEGORY" : {
330 "dataType" : "picklist",
331 "filterValues" : [ {
332 "label" : "Omitted",
333 "name" : "Omitted"
334 }, {
335 "label" : "Pipeline",
336 "name" : "Pipeline"
337 }, {
338 "label" : "Best Case",
339 "name" : "Best Case"
340 }, {
341 "label" : "Commit",
342 "name" : "Commit"
343 }, {
344 "label" : "Closed",
345 "name" : "Closed"
346 } ],
347 "filterable" : true,
348 "label" : "Forecast Category"
349 },
350 "OPPORTUNITY_ID" : {
351 "dataType" : "id",
352 "filterValues" : [ ],
353 "filterable" : true,
354 "label" : "Opportunity ID"
355 },
356 "LAST_ACTIVITY" : {
357 "dataType" : "date",
358 "filterValues" : [ ],
359 "filterable" : true,
360 "label" : "Last Activity"
361 },
362 "DESCRIPTION" : {
363 "dataType" : "textarea",
364 "filterValues" : [ ],
365 "filterable" : true,
366 "label" : "Description"
367 },
368 "HASOPPLINEITEM" : {
369 "dataType" : "boolean",
370 "filterValues" : [ {
371 "label" : "True",
372 "name" : "True"
373 }, {
374 "label" : "False",
375 "name" : "False"
376 } ],
377 "filterable" : true,
378 "label" : "Has Products"
379 },
380 "CREATED_DATE" : {
381 "dataType" : "datetime",
382 "filterValues" : [ ],
383 "filterable" : true,
384 "label" : "Created Date"
385 },
386 "LAST_UPDATE" : {
387 "dataType" : "datetime",
388 "filterValues" : [ ],
389 "filterable" : true,
390 "label" : "Last Modified Date"
391 }
392 },
393 "label" : "Opportunity Information"
394 }, {
395 "columns" : {
396 "FULL_NAME" : {
397 "dataType" : "string",
398 "filterValues" : [ ],
399 "filterable" : true,
400 "label" : "Opportunity Owner"
401 },
402 "ROLLUP_DESCRIPTION" : {
403 "dataType" : "string",
404 "filterValues" : [ ],
405 "filterable" : true,
406 "label" : "Owner Role"
407 },
408 "ALIAS" : {
409 "dataType" : "string",
410 "filterValues" : [ ],
411 "filterable" : true,
412 "label" : "Opportunity Owner Alias"
413 },
414 "OWNER_EMAIL" : {
415 "dataType" : "email",
416 "filterValues" : [ ],
417 "filterable" : true,
418 "label" : "Opportunity Owner Email"
419 },
420 "OWNER_PHONE" : {
421 "dataType" : "phone",
422 "filterValues" : [ ],
423 "filterable" : true,
424 "label" : "Opportunity Owner: Phone"
425 },
426 "OWNER_MOBILE_PHONE" : {
427 "dataType" : "phone",
428 "filterValues" : [ ],
429 "filterable" : true,
430 "label" : "Opportunity Owner: Mobile Phone"
431 },
432 "OWNER_MANAGER" : {
433 "dataType" : "string",
434 "filterValues" : [ ],
435 "filterable" : true,
436 "label" : "Opportunity Owner: Manager"
437 },
438 "OWNER_TITLE" : {
439 "dataType" : "string",
440 "filterValues" : [ ],
441 "filterable" : true,
442 "label" : "Opportunity Owner: Title"
443 },
444 "OWNER_COMPANY" : {
445 "dataType" : "string",
446 "filterValues" : [ ],
447 "filterable" : true,
448 "label" : "Opportunity Owner: Company"
449 },
450 "OWNER_DEPARTMENT" : {
451 "dataType" : "string",
452 "filterValues" : [ ],
453 "filterable" : true,
454 "label" : "Opportunity Owner: Department"
455 },
456 "OWNER_DIVISION" : {
457 "dataType" : "string",
458 "filterValues" : [ ],
459 "filterable" : true,
460 "label" : "Opportunity Owner: Division"
461 },
462 "OWNER_PROFILE" : {
463 "dataType" : "string",
464 "filterValues" : [ ],
465 "filterable" : true,
466 "label" : "Opportunity Owner: Profile"
467 },
468 "OWNER_ACTIVE" : {
469 "dataType" : "boolean",
470 "filterValues" : [ {
471 "label" : "True",
472 "name" : "True"
473 }, {
474 "label" : "False",
475 "name" : "False"
476 } ],
477 "filterable" : true,
478 "label" : "Opportunity Owner: Active"
479 }
480 },
481 "label" : "Opportunity Owner Information"
482 }, {
483 "columns" : {
484 "ACCOUNT_NAME" : {
485 "dataType" : "string",
486 "filterValues" : [ ],
487 "filterable" : true,
488 "label" : "Account Name"
489 },
490 "ACCOUNT_OWNER" : {
491 "dataType" : "string",
492 "filterValues" : [ ],
493 "filterable" : true,
494 "label" : "Account Owner"
495 },
496 "ACCOUNT_OWNER_ALIAS" : {
497 "dataType" : "string",
498 "filterValues" : [ ],
499 "filterable" : true,
500 "label" : "Account Owner Alias"
501 },
502 "PARENT_NAME" : {
503 "dataType" : "string",
504 "filterValues" : [ ],
505 "filterable" : true,
506 "label" : "Parent Account"
507 },
508 "PARENT_ID" : {
509 "dataType" : "id",
510 "filterValues" : [ ],
511 "filterable" : true,
512 "label" : "Parent Account ID"
513 },
514 "SALES" : {
515 "dataType" : "currency",
516 "filterValues" : [ ],
517 "filterable" : true,
518 "label" : "Annual Revenue"
519 },
520 "ACCOUNT_TYPE" : {
521 "dataType" : "picklist",
522 "filterValues" : [ {
523 "label" : "Analyst",
524 "name" : "Analyst"
525 }, {
526 "label" : "Competitor",
527 "name" : "Competitor"
528 }, {
529 "label" : "Customer",
530 "name" : "Customer"
531 }, {
532 "label" : "Integrator",
533 "name" : "Integrator"
534 }, {
535 "label" : "Investor",
536 "name" : "Investor"
537 }, {
538 "label" : "Partner",
539 "name" : "Partner"
540 }, {
541 "label" : "Press",
542 "name" : "Press"
543 }, {
544 "label" : "Prospect",
545 "name" : "Prospect"
546 }, {
547 "label" : "Reseller",
548 "name" : "Reseller"
549 }, {
550 "label" : "Other",
551 "name" : "Other"
552 } ],
553 "filterable" : true,
554 "label" : "Account Type"
555 },
556 "INDUSTRY" : {
557 "dataType" : "picklist",
558 "filterValues" : [ {
559 "label" : "Agriculture",
560 "name" : "Agriculture"
561 }, {
562 "label" : "Apparel",
563 "name" : "Apparel"
564 }, {
565 "label" : "Banking",
566 "name" : "Banking"
567 }, {
568 "label" : "Biotechnology",
569 "name" : "Biotechnology"
570 }, {
571 "label" : "Chemicals",
572 "name" : "Chemicals"
573 }, {
574 "label" : "Communications",
575 "name" : "Communications"
576 }, {
577 "label" : "Construction",
578 "name" : "Construction"
579 }, {
580 "label" : "Consulting",
581 "name" : "Consulting"
582 }, {
583 "label" : "Education",
584 "name" : "Education"
585 }, {
586 "label" : "Electronics",
587 "name" : "Electronics"
588 }, {
589 "label" : "Energy",
590 "name" : "Energy"
591 }, {
592 "label" : "Engineering",
593 "name" : "Engineering"
594 }, {
595 "label" : "Entertainment",
596 "name" : "Entertainment"
597 }, {
598 "label" : "Environmental",
599 "name" : "Environmental"
600 }, {
601 "label" : "Finance",
602 "name" : "Finance"
603 }, {
604 "label" : "Food & Beverage",
605 "name" : "Food & Beverage"
606 }, {
607 "label" : "Government",
608 "name" : "Government"
609 }, {
610 "label" : "Healthcare",
611 "name" : "Healthcare"
612 }, {
613 "label" : "Hospitality",
614 "name" : "Hospitality"
615 }, {
616 "label" : "Insurance",
617 "name" : "Insurance"
618 }, {
619 "label" : "Machinery",
620 "name" : "Machinery"
621 }, {
622 "label" : "Manufacturing",
623 "name" : "Manufacturing"
624 }, {
625 "label" : "Media",
626 "name" : "Media"
627 }, {
628 "label" : "Not For Profit",
629 "name" : "Not For Profit"
630 }, {
631 "label" : "Other",
632 "name" : "Other"
633 }, {
634 "label" : "Recreation",
635 "name" : "Recreation"
636 }, {
637 "label" : "Retail",
638 "name" : "Retail"
639 }, {
640 "label" : "Shipping",
641 "name" : "Shipping"
642 }, {
643 "label" : "Technology",
644 "name" : "Technology"
645 }, {
646 "label" : "Telecommunications",
647 "name" : "Telecommunications"
648 }, {
649 "label" : "Transportation",
650 "name" : "Transportation"
651 }, {
652 "label" : "Utilities",
653 "name" : "Utilities"
654 } ],
655 "filterable" : true,
656 "label" : "Industry"
657 },
658 "EMPLOYEES" : {
659 "dataType" : "int",
660 "filterValues" : [ ],
661 "filterable" : true,
662 "label" : "Employees"
663 },
664 "ACCOUNT_ID" : {
665 "dataType" : "id",
666 "filterValues" : [ ],
667 "filterable" : true,
668 "label" : "Account ID"
669 },
670 "ACCOUNT_LAST_ACTIVITY" : {
671 "dataType" : "date",
672 "filterValues" : [ ],
673 "filterable" : true,
674 "label" : "Account: Last Activity"
675 },
676 "ACCOUNT_CREATED_DATE" : {
677 "dataType" : "datetime",
678 "filterValues" : [ ],
679 "filterable" : true,
680 "label" : "Account: Created Date"
681 },
682 "ACCOUNT_LAST_UPDATE" : {
683 "dataType" : "datetime",
684 "filterValues" : [ ],
685 "filterable" : true,
686 "label" : "Account: Last Modified Date"
687 },
688 "ACCOUNT_DESCRIPTION" : {
689 "dataType" : "textarea",
690 "filterValues" : [ ],
691 "filterable" : true,
692 "label" : "Account Description"
693 }
694 },
695 "label" : "Account: General"
696 }, {
697 "columns" : {
698 "ADDRESS1_STREET" : {
699 "dataType" : "textarea",
700 "filterValues" : [ ],
701 "filterable" : true,
702 "label" : "Billing Street"
703 },
704 "ADDRESS1_LINE1" : {
705 "dataType" : "string",
706 "filterValues" : [ ],
707 "filterable" : true,
708 "label" : "Billing Address Line 1"
709 },
710 "ADDRESS1_LINE2" : {
711 "dataType" : "string",
712 "filterValues" : [ ],
713 "filterable" : true,
714 "label" : "Billing Address Line 2"
715 },
716 "ADDRESS1_LINE3" : {
717 "dataType" : "string",
718 "filterValues" : [ ],
719 "filterable" : true,
720 "label" : "Billing Address Line 3"
721 },
722 "ADDRESS1_CITY" : {
723 "dataType" : "string",
724 "filterValues" : [ ],
725 "filterable" : true,
726 "label" : "Billing City"
727 },
728 "ADDRESS1_STATE" : {
729 "dataType" : "string",
730 "filterValues" : [ ],
731 "filterable" : true,
732 "label" : "Billing State/Province"
733 },
734 "ADDRESS1_ZIP" : {
735 "dataType" : "string",
736 "filterValues" : [ ],
737 "filterable" : true,
738 "label" : "Billing Zip/Postal Code"
739 },
740 "ADDRESS1_COUNTRY" : {
741 "dataType" : "string",
742 "filterValues" : [ ],
743 "filterable" : true,
744 "label" : "Billing Country"
745 },
746 "ADDRESS2_STREET" : {
747 "dataType" : "textarea",
748 "filterValues" : [ ],
749 "filterable" : true,
750 "label" : "Shipping Street"
751 },
752 "ADDRESS2_LINE1" : {
753 "dataType" : "string",
754 "filterValues" : [ ],
755 "filterable" : true,
756 "label" : "Shipping Address Line 1"
757 },
758 "ADDRESS2_LINE2" : {
759 "dataType" : "string",
760 "filterValues" : [ ],
761 "filterable" : true,
762 "label" : "Shipping Address Line 2"
763 },
764 "ADDRESS2_LINE3" : {
765 "dataType" : "string",
766 "filterValues" : [ ],
767 "filterable" : true,
768 "label" : "Shipping Address Line 3"
769 },
770 "ADDRESS2_CITY" : {
771 "dataType" : "string",
772 "filterValues" : [ ],
773 "filterable" : true,
774 "label" : "Shipping City"
775 },
776 "ADDRESS2_STATE" : {
777 "dataType" : "string",
778 "filterValues" : [ ],
779 "filterable" : true,
780 "label" : "Shipping State/Province"
781 },
782 "ADDRESS2_ZIP" : {
783 "dataType" : "string",
784 "filterValues" : [ ],
785 "filterable" : true,
786 "label" : "Shipping Zip/Postal Code"
787 },
788 "ADDRESS2_COUNTRY" : {
789 "dataType" : "string",
790 "filterValues" : [ ],
791 "filterable" : true,
792 "label" : "Shipping Country"
793 }
794 },
795 "label" : "Account: Address"
796 }, {
797 "columns" : {
798 "PHONE1" : {
799 "dataType" : "phone",
800 "filterValues" : [ ],
801 "filterable" : true,
802 "label" : "Phone"
803 },
804 "PHONE2" : {
805 "dataType" : "phone",
806 "filterValues" : [ ],
807 "filterable" : true,
808 "label" : "Fax"
809 },
810 "URL" : {
811 "dataType" : "url",
812 "filterValues" : [ ],
813 "filterable" : true,
814 "label" : "Website"
815 }
816 },
817 "label" : "Account: Ph/Fax"
818 }, {
819 "columns" : {
820 "CONTACT" : {
821 "dataType" : "string",
822 "filterValues" : [ ],
823 "filterable" : true,
824 "label" : "Primary Contact"
825 },
826 "CON.TITLE" : {
827 "dataType" : "string",
828 "filterValues" : [ ],
829 "filterable" : true,
830 "label" : "Contact: Title"
831 },
832 "CON.PHONE" : {
833 "dataType" : "phone",
834 "filterValues" : [ ],
835 "filterable" : true,
836 "label" : "Contact: Phone"
837 },
838 "CON.EMAIL" : {
839 "dataType" : "email",
840 "filterValues" : [ ],
841 "filterable" : true,
842 "label" : "Contact: Email"
843 }
844 },
845 "label" : "Primary Contact"
846 }, {
847 "columns" : {
848 "CON.ADDRESS2_STREET" : {
849 "dataType" : "textarea",
850 "filterValues" : [ ],
851 "filterable" : true,
852 "label" : "Mailing Street"
853 },
854 "CON.ADDRESS2_LINE1" : {
855 "dataType" : "string",
856 "filterValues" : [ ],
857 "filterable" : true,
858 "label" : "Mailing Address Line 1"
859 },
860 "CON.ADDRESS2_LINE2" : {
861 "dataType" : "string",
862 "filterValues" : [ ],
863 "filterable" : true,
864 "label" : "Mailing Address Line 2"
865 },
866 "CON.ADDRESS2_LINE3" : {
867 "dataType" : "string",
868 "filterValues" : [ ],
869 "filterable" : true,
870 "label" : "Mailing Address Line 3"
871 },
872 "CON.ADDRESS2_CITY" : {
873 "dataType" : "string",
874 "filterValues" : [ ],
875 "filterable" : true,
876 "label" : "Mailing City"
877 },
878 "CON.ADDRESS2_STATE" : {
879 "dataType" : "string",
880 "filterValues" : [ ],
881 "filterable" : true,
882 "label" : "Mailing State/Province"
883 },
884 "CON.ADDRESS2_ZIP" : {
885 "dataType" : "string",
886 "filterValues" : [ ],
887 "filterable" : true,
888 "label" : "Mailing Zip/Postal Code"
889 },
890 "CON.ADDRESS2_COUNTRY" : {
891 "dataType" : "string",
892 "filterValues" : [ ],
893 "filterable" : true,
894 "label" : "Mailing Country"
895 },
896 "CON.ADDRESS1_STREET" : {
897 "dataType" : "textarea",
898 "filterValues" : [ ],
899 "filterable" : true,
900 "label" : "Other Street"
901 },
902 "CON.ADDRESS1_LINE1" : {
903 "dataType" : "string",
904 "filterValues" : [ ],
905 "filterable" : true,
906 "label" : "Other Address Line 1"
907 },
908 "CON.ADDRESS1_LINE2" : {
909 "dataType" : "string",
910 "filterValues" : [ ],
911 "filterable" : true,
912 "label" : "Other Address Line 2"
913 },
914 "CON.ADDRESS1_LINE3" : {
915 "dataType" : "string",
916 "filterValues" : [ ],
917 "filterable" : true,
918 "label" : "Other Address Line 3"
919 },
920 "CON.ADDRESS1_CITY" : {
921 "dataType" : "string",
922 "filterValues" : [ ],
923 "filterable" : true,
924 "label" : "Other City"
925 },
926 "CON.ADDRESS1_STATE" : {
927 "dataType" : "string",
928 "filterValues" : [ ],
929 "filterable" : true,
930 "label" : "Other State/Province"
931 },
932 "CON.ADDRESS1_ZIP" : {
933 "dataType" : "string",
934 "filterValues" : [ ],
935 "filterable" : true,
936 "label" : "Other Zip/Postal Code"
937 },
938 "CON.ADDRESS1_COUNTRY" : {
939 "dataType" : "string",
940 "filterValues" : [ ],
941 "filterable" : true,
942 "label" : "Other Country"
943 }
944 },
945 "label" : "Contact: Address"
946 } ],
947 "dataTypeFilterOperatorMap" : {
948 "date" : [ {
949 "label" : "equals",
950 "name" : "equals"
951 }, {
952 "label" : "not equal to",
953 "name" : "notEqual"
954 }, {
955 "label" : "less than",
956 "name" : "lessThan"
957 }, {
958 "label" : "greater than",
959 "name" : "greaterThan"
960 }, {
961 "label" : "less or equal",
962 "name" : "lessOrEqual"
963 }, {
964 "label" : "greater or equal",
965 "name" : "greaterOrEqual"
966 } ],
967 "string" : [ {
968 "label" : "equals",
969 "name" : "equals"
970 }, {
971 "label" : "not equal to",
972 "name" : "notEqual"
973 }, {
974 "label" : "less than",
975 "name" : "lessThan"
976 }, {
977 "label" : "greater than",
978 "name" : "greaterThan"
979 }, {
980 "label" : "less or equal",
981 "name" : "lessOrEqual"
982 }, {
983 "label" : "greater or equal",
984 "name" : "greaterOrEqual"
985 }, {
986 "label" : "contains",
987 "name" : "contains"
988 }, {
989 "label" : "does not contain",
990 "name" : "notContain"
991 }, {
992 "label" : "starts with",
993 "name" : "startsWith"
994 } ],
995 "picklist" : [ {
996 "label" : "equals",
997 "name" : "equals"
998 }, {
999 "label" : "not equal to",
1000 "name" : "notEqual"
1001 }, {
1002 "label" : "less than",
1003 "name" : "lessThan"
1004 }, {
1005 "label" : "greater than",
1006 "name" : "greaterThan"
1007 }, {
1008 "label" : "less or equal",
1009 "name" : "lessOrEqual"
1010 }, {
1011 "label" : "greater or equal",
1012 "name" : "greaterOrEqual"
1013 }, {
1014 "label" : "contains",
1015 "name" : "contains"
1016 }, {
1017 "label" : "does not contain",
1018 "name" : "notContain"
1019 }, {
1020 "label" : "starts with",
1021 "name" : "startsWith"
1022 } ],
1023 "textarea" : [ {
1024 "label" : "equals",
1025 "name" : "equals"
1026 }, {
1027 "label" : "not equal to",
1028 "name" : "notEqual"
1029 }, {
1030 "label" : "less than",
1031 "name" : "lessThan"
1032 }, {
1033 "label" : "greater than",
1034 "name" : "greaterThan"
1035 }, {
1036 "label" : "less or equal",
1037 "name" : "lessOrEqual"
1038 }, {
1039 "label" : "greater or equal",
1040 "name" : "greaterOrEqual"
1041 }, {
1042 "label" : "contains",
1043 "name" : "contains"
1044 }, {
1045 "label" : "does not contain",
1046 "name" : "notContain"
1047 }, {
1048 "label" : "starts with",
1049 "name" : "startsWith"
1050 } ],
1051 "percent" : [ {
1052 "label" : "equals",
1053 "name" : "equals"
1054 }, {
1055 "label" : "not equal to",
1056 "name" : "notEqual"
1057 }, {
1058 "label" : "less than",
1059 "name" : "lessThan"
1060 }, {
1061 "label" : "greater than",
1062 "name" : "greaterThan"
1063 }, {
1064 "label" : "less or equal",
1065 "name" : "lessOrEqual"
1066 }, {
1067 "label" : "greater or equal",
1068 "name" : "greaterOrEqual"
1069 } ],
1070 "int" : [ {
1071 "label" : "equals",
1072 "name" : "equals"
1073 }, {
1074 "label" : "not equal to",
1075 "name" : "notEqual"
1076 }, {
1077 "label" : "less than",
1078 "name" : "lessThan"
1079 }, {
1080 "label" : "greater than",
1081 "name" : "greaterThan"
1082 }, {
1083 "label" : "less or equal",
1084 "name" : "lessOrEqual"
1085 }, {
1086 "label" : "greater or equal",
1087 "name" : "greaterOrEqual"
1088 } ],
1089 "url" : [ {
1090 "label" : "equals",
1091 "name" : "equals"
1092 }, {
1093 "label" : "not equal to",
1094 "name" : "notEqual"
1095 }, {
1096 "label" : "less than",
1097 "name" : "lessThan"
1098 }, {
1099 "label" : "greater than",
1100 "name" : "greaterThan"
1101 }, {
1102 "label" : "less or equal",
1103 "name" : "lessOrEqual"
1104 }, {
1105 "label" : "greater or equal",
1106 "name" : "greaterOrEqual"
1107 }, {
1108 "label" : "contains",
1109 "name" : "contains"
1110 }, {
1111 "label" : "does not contain",
1112 "name" : "notContain"
1113 }, {
1114 "label" : "starts with",
1115 "name" : "startsWith"
1116 } ],
1117 "datetime" : [ {
1118 "label" : "equals",
1119 "name" : "equals"
1120 }, {
1121 "label" : "not equal to",
1122 "name" : "notEqual"
1123 }, {
1124 "label" : "less than",
1125 "name" : "lessThan"
1126 }, {
1127 "label" : "greater than",
1128 "name" : "greaterThan"
1129 }, {
1130 "label" : "less or equal",
1131 "name" : "lessOrEqual"
1132 }, {
1133 "label" : "greater or equal",
1134 "name" : "greaterOrEqual"
1135 } ],
1136 "boolean" : [ {
1137 "label" : "equals",
1138 "name" : "equals"
1139 }, {
1140 "label" : "not equal to",
1141 "name" : "notEqual"
1142 } ],
1143 "phone" : [ {
1144 "label" : "equals",
1145 "name" : "equals"
1146 }, {
1147 "label" : "not equal to",
1148 "name" : "notEqual"
1149 }, {
1150 "label" : "less than",
1151 "name" : "lessThan"
1152 }, {
1153 "label" : "greater than",
1154 "name" : "greaterThan"
1155 }, {
1156 "label" : "less or equal",
1157 "name" : "lessOrEqual"
1158 }, {
1159 "label" : "greater or equal",
1160 "name" : "greaterOrEqual"
1161 }, {
1162 "label" : "contains",
1163 "name" : "contains"
1164 }, {
1165 "label" : "does not contain",
1166 "name" : "notContain"
1167 }, {
1168 "label" : "starts with",
1169 "name" : "startsWith"
1170 } ],
1171 "currency" : [ {
1172 "label" : "equals",
1173 "name" : "equals"
1174 }, {
1175 "label" : "not equal to",
1176 "name" : "notEqual"
1177 }, {
1178 "label" : "less than",
1179 "name" : "lessThan"
1180 }, {
1181 "label" : "greater than",
1182 "name" : "greaterThan"
1183 }, {
1184 "label" : "less or equal",
1185 "name" : "lessOrEqual"
1186 }, {
1187 "label" : "greater or equal",
1188 "name" : "greaterOrEqual"
1189 } ],
1190 "id" : [ {
1191 "label" : "equals",
1192 "name" : "equals"
1193 }, {
1194 "label" : "not equal to",
1195 "name" : "notEqual"
1196 }, {
1197 "label" : "starts with",
1198 "name" : "startsWith"
1199 } ],
1200 "email" : [ {
1201 "label" : "equals",
1202 "name" : "equals"
1203 }, {
1204 "label" : "not equal to",
1205 "name" : "notEqual"
1206 }, {
1207 "label" : "less than",
1208 "name" : "lessThan"
1209 }, {
1210 "label" : "greater than",
1211 "name" : "greaterThan"
1212 }, {
1213 "label" : "less or equal",
1214 "name" : "lessOrEqual"
1215 }, {
1216 "label" : "greater or equal",
1217 "name" : "greaterOrEqual"
1218 }, {
1219 "label" : "contains",
1220 "name" : "contains"
1221 }, {
1222 "label" : "does not contain",
1223 "name" : "notContain"
1224 }, {
1225 "label" : "starts with",
1226 "name" : "startsWith"
1227 } ]
1228 },
1229 "divisionInfo" : null,
1230 "scopeInfo" : {
1231 "defaultValue" : "organization",
1232 "values" : [ {
1233 "allowsDivision" : false,
1234 "label" : "My opportunities",
1235 "value" : "user"
1236 }, {
1237 "allowsDivision" : false,
1238 "label" : "My team's opportunities",
1239 "value" : "team"
1240 }, {
1241 "allowsDivision" : true,
1242 "label" : "All opportunities",
1243 "value" : "organization"
1244 } ]
1245 },
1246 "standardDateFilterDurationGroups" : [ {
1247 "label" : "",
1248 "standardDateFilterDurations" : [ {
1249 "endDate" : "2016-12-12",
1250 "label" : "Custom",
1251 "startDate" : "2016-12-13",
1252 "value" : "CUSTOM"
1253 } ]
1254 }, {
1255 "label" : "Fiscal Year",
1256 "standardDateFilterDurations" : [ {
1257 "endDate" : "2016-12-31",
1258 "label" : "Current FY",
1259 "startDate" : "2016-01-01",
1260 "value" : "THIS_FISCAL_YEAR"
1261 }, {
1262 "endDate" : "2015-12-31",
1263 "label" : "Previous FY",
1264 "startDate" : "2015-01-01",
1265 "value" : "LAST_FISCAL_YEAR"
1266 }, {
1267 "endDate" : "2015-12-31",
1268 "label" : "Previous 2 FY",
1269 "startDate" : "2014-01-01",
1270 "value" : "LAST_N_FISCAL_YEARS:2"
1271 }, {
1272 "endDate" : "2014-12-31",
1273 "label" : "2 FY Ago",
1274 "startDate" : "2014-01-01",
1275 "value" : "LAST_N_FISCAL_YEARS_AGO:2"
1276 }, {
1277 "endDate" : "2017-12-31",
1278 "label" : "Next FY",
1279 "startDate" : "2017-01-01",
1280 "value" : "NEXT_FISCAL_YEAR"
1281 }, {
1282 "endDate" : "2016-12-31",
1283 "label" : "Current and Previous FY",
1284 "startDate" : "2015-01-01",
1285 "value" : "THIS_AND_LAST_FISCAL_YEAR:2"
1286 }, {
1287 "endDate" : "2016-12-31",
1288 "label" : "Current and Previous 2 FY",
1289 "startDate" : "2014-01-01",
1290 "value" : "THIS_AND_LAST_N_FISCAL_YEARS:2"
1291 }, {
1292 "endDate" : "2017-12-31",
1293 "label" : "Current and Next FY",
1294 "startDate" : "2016-01-01",
1295 "value" : "THIS_AND_NEXT_FISCAL_YEAR"
1296 } ]
1297 }, {
1298 "label" : "Fiscal Quarter",
1299 "standardDateFilterDurations" : [ {
1300 "endDate" : "2016-12-31",
1301 "label" : "Current FQ",
1302 "startDate" : "2016-10-01",
1303 "value" : "THIS_FISCAL_QUARTER"
1304 }, {
1305 "endDate" : "2017-03-31",
1306 "label" : "Current and Next FQ",
1307 "startDate" : "2016-10-01",
1308 "value" : "THIS_AND_NEXT_FISCAL_QUARTER"
1309 }, {
1310 "endDate" : "2016-12-31",
1311 "label" : "Current and Previous FQ",
1312 "startDate" : "2016-07-01",
1313 "value" : "LAST_AND_THIS_FISCAL_QUARTER"
1314 }, {
1315 "endDate" : "2017-03-31",
1316 "label" : "Next FQ",
1317 "startDate" : "2017-01-01",
1318 "value" : "NEXT_FISCAL_QUARTER"
1319 }, {
1320 "endDate" : "2016-09-30",
1321 "label" : "Previous FQ",
1322 "startDate" : "2016-07-01",
1323 "value" : "LAST_FISCAL_QUARTER"
1324 }, {
1325 "endDate" : "2017-09-30",
1326 "label" : "Current and Next 3 FQ",
1327 "startDate" : "2016-10-01",
1328 "value" : "THIS_AND_NEXT_N_FISCAL_QUARTERS:3"
1329 } ]
1330 }, {
1331 "label" : "Calendar Year",
1332 "standardDateFilterDurations" : [ {
1333 "endDate" : "2016-12-31",
1334 "label" : "Current CY",
1335 "startDate" : "2016-01-01",
1336 "value" : "THIS_YEAR"
1337 }, {
1338 "endDate" : "2015-12-31",
1339 "label" : "Previous CY",
1340 "startDate" : "2015-01-01",
1341 "value" : "LAST_YEAR"
1342 }, {
1343 "endDate" : "2015-12-31",
1344 "label" : "Previous 2 CY",
1345 "startDate" : "2014-01-01",
1346 "value" : "LAST_N_YEARS:2"
1347 }, {
1348 "endDate" : "2014-12-31",
1349 "label" : "2 CY Ago",
1350 "startDate" : "2014-01-01",
1351 "value" : "LAST_N_YEARS_AGO:2"
1352 }, {
1353 "endDate" : "2017-12-31",
1354 "label" : "Next CY",
1355 "startDate" : "2017-01-01",
1356 "value" : "NEXT_YEAR"
1357 }, {
1358 "endDate" : "2016-12-31",
1359 "label" : "Current and Previous CY",
1360 "startDate" : "2015-01-01",
1361 "value" : "THIS_AND_LAST_YEAR:2"
1362 }, {
1363 "endDate" : "2016-12-31",
1364 "label" : "Current and Previous 2 CY",
1365 "startDate" : "2014-01-01",
1366 "value" : "THIS_AND_LAST_N_YEARS:2"
1367 }, {
1368 "endDate" : "2017-12-31",
1369 "label" : "Current and Next CY",
1370 "startDate" : "2016-01-01",
1371 "value" : "THIS_AND_NEXT_YEAR"
1372 } ]
1373 }, {
1374 "label" : "Calendar Quarter",
1375 "standardDateFilterDurations" : [ {
1376 "endDate" : "2016-12-31",
1377 "label" : "Current CQ",
1378 "startDate" : "2016-10-01",
1379 "value" : "THIS_QUARTER"
1380 }, {
1381 "endDate" : "2017-03-31",
1382 "label" : "Current and Next CQ",
1383 "startDate" : "2016-10-01",
1384 "value" : "THIS_AND_NEXT_QUARTER"
1385 }, {
1386 "endDate" : "2016-12-31",
1387 "label" : "Current and Previous CQ",
1388 "startDate" : "2016-07-01",
1389 "value" : "LAST_AND_THIS_QUARTER"
1390 }, {
1391 "endDate" : "2017-03-31",
1392 "label" : "Next CQ",
1393 "startDate" : "2017-01-01",
1394 "value" : "NEXT_QUARTER"
1395 }, {
1396 "endDate" : "2016-09-30",
1397 "label" : "Previous CQ",
1398 "startDate" : "2016-07-01",
1399 "value" : "LAST_QUARTER"
1400 }, {
1401 "endDate" : "2017-09-30",
1402 "label" : "Current and Next 3 CQ",
1403 "startDate" : "2016-10-01",
1404 "value" : "THIS_AND_NEXT_N_QUARTERS:3"
1405 } ]
1406 }, {
1407 "label" : "Calendar Month",
1408 "standardDateFilterDurations" : [ {
1409 "endDate" : "2016-11-30",
1410 "label" : "Last Month",
1411 "startDate" : "2016-11-01",
1412 "value" : "LAST_MONTH"
1413 }, {
1414 "endDate" : "2016-12-31",
1415 "label" : "This Month",
1416 "startDate" : "2016-12-01",
1417 "value" : "THIS_MONTH"
1418 }, {
1419 "endDate" : "2017-01-31",
1420 "label" : "Next Month",
1421 "startDate" : "2017-01-01",
1422 "value" : "NEXT_MONTH"
1423 }, {
1424 "endDate" : "2016-12-31",
1425 "label" : "Current and Previous Month",
1426 "startDate" : "2016-11-01",
1427 "value" : "LAST_AND_THIS_MONTH"
1428 }, {
1429 "endDate" : "2017-01-31",
1430 "label" : "Current and Next Month",
1431 "startDate" : "2016-12-01",
1432 "value" : "THIS_AND_NEXT_MONTH"
1433 } ]
1434 }, {
1435 "label" : "Calendar Week",
1436 "standardDateFilterDurations" : [ {
1437 "endDate" : "2016-12-10",
1438 "label" : "Last Week",
1439 "startDate" : "2016-12-04",
1440 "value" : "LAST_WEEK"
1441 }, {
1442 "endDate" : "2016-12-17",
1443 "label" : "This Week",
1444 "startDate" : "2016-12-11",
1445 "value" : "THIS_WEEK"
1446 }, {
1447 "endDate" : "2016-12-24",
1448 "label" : "Next Week",
1449 "startDate" : "2016-12-18",
1450 "value" : "NEXT_WEEK"
1451 } ]
1452 }, {
1453 "label" : "Day",
1454 "standardDateFilterDurations" : [ {
1455 "endDate" : "2016-12-12",
1456 "label" : "Yesterday",
1457 "startDate" : "2016-12-12",
1458 "value" : "YESTERDAY"
1459 }, {
1460 "endDate" : "2016-12-13",
1461 "label" : "Today",
1462 "startDate" : "2016-12-13",
1463 "value" : "TODAY"
1464 }, {
1465 "endDate" : "2016-12-14",
1466 "label" : "Tomorrow",
1467 "startDate" : "2016-12-14",
1468 "value" : "TOMORROW"
1469 }, {
1470 "endDate" : "2016-12-13",
1471 "label" : "Last 7 Days",
1472 "startDate" : "2016-12-07",
1473 "value" : "LAST_N_DAYS:7"
1474 }, {
1475 "endDate" : "2016-12-13",
1476 "label" : "Last 30 Days",
1477 "startDate" : "2016-11-14",
1478 "value" : "LAST_N_DAYS:30"
1479 }, {
1480 "endDate" : "2016-12-13",
1481 "label" : "Last 60 Days",
1482 "startDate" : "2016-10-15",
1483 "value" : "LAST_N_DAYS:60"
1484 }, {
1485 "endDate" : "2016-12-13",
1486 "label" : "Last 90 Days",
1487 "startDate" : "2016-09-15",
1488 "value" : "LAST_N_DAYS:90"
1489 }, {
1490 "endDate" : "2016-12-13",
1491 "label" : "Last 120 Days",
1492 "startDate" : "2016-08-16",
1493 "value" : "LAST_N_DAYS:120"
1494 }, {
1495 "endDate" : "2016-12-19",
1496 "label" : "Next 7 Days",
1497 "startDate" : "2016-12-13",
1498 "value" : "NEXT_N_DAYS:7"
1499 }, {
1500 "endDate" : "2017-01-11",
1501 "label" : "Next 30 Days",
1502 "startDate" : "2016-12-13",
1503 "value" : "NEXT_N_DAYS:30"
1504 }, {
1505 "endDate" : "2017-02-10",
1506 "label" : "Next 60 Days",
1507 "startDate" : "2016-12-13",
1508 "value" : "NEXT_N_DAYS:60"
1509 }, {
1510 "endDate" : "2017-03-12",
1511 "label" : "Next 90 Days",
1512 "startDate" : "2016-12-13",
1513 "value" : "NEXT_N_DAYS:90"
1514 }, {
1515 "endDate" : "2017-04-11",
1516 "label" : "Next 120 Days",
1517 "startDate" : "2016-12-13",
1518 "value" : "NEXT_N_DAYS:120"
1519 } ]
1520 } ],
1521 "standardFilterInfos" : {
1522 "probability" : {
1523 "type" : "PICKLIST",
1524 "filterValues" : [ {
1525 "label" : "All",
1526 "name" : ">0"
1527 }, {
1528 "label" : "> 90%",
1529 "name" : "gt90"
1530 }, {
1531 "label" : "> 80%",
1532 "name" : "gt80"
1533 }, {
1534 "label" : "> 70%",
1535 "name" : "gt70"
1536 }, {
1537 "label" : "> 60%",
1538 "name" : "gt60"
1539 }, {
1540 "label" : "> 50%",
1541 "name" : "gt50"
1542 }, {
1543 "label" : "> 40%",
1544 "name" : "gt40"
1545 }, {
1546 "label" : "> 30%",
1547 "name" : "gt30"
1548 }, {
1549 "label" : "> 20%",
1550 "name" : "gt20"
1551 }, {
1552 "label" : "> 10%",
1553 "name" : "gt10"
1554 }, {
1555 "label" : "< 90%",
1556 "name" : "lt90"
1557 }, {
1558 "label" : "< 80%",
1559 "name" : "lt80"
1560 }, {
1561 "label" : "< 70%",
1562 "name" : "lt70"
1563 }, {
1564 "label" : "< 60%",
1565 "name" : "lt60"
1566 }, {
1567 "label" : "< 50%",
1568 "name" : "lt50"
1569 }, {
1570 "label" : "< 40%",
1571 "name" : "lt40"
1572 }, {
1573 "label" : "< 30%",
1574 "name" : "lt30"
1575 }, {
1576 "label" : "< 20%",
1577 "name" : "lt20"
1578 }, {
1579 "label" : "< 10%",
1580 "name" : "lt10"
1581 } ],
1582 "label" : "Probability"
1583 },
1584 "open" : {
1585 "type" : "PICKLIST",
1586 "filterValues" : [ {
1587 "label" : "Any",
1588 "name" : "all"
1589 }, {
1590 "label" : "Open",
1591 "name" : "open"
1592 }, {
1593 "label" : "Closed",
1594 "name" : "closed"
1595 }, {
1596 "label" : "Closed Won",
1597 "name" : "closedwon"
1598 } ],
1599 "label" : "Opportunity Status"
1600 }
1601 }
1602 }
1603}
j