---
title: "Get Main Table Data V2"
slug: "get-main-table-data-v2"
updated: 2026-01-29T13:55:27Z
published: 2026-01-29T13:55:52Z
canonical: "documents.revsure.ai/get-main-table-data-v2"
---
> ## Documentation Index
> Fetch the complete documentation index at: https://documents.revsure.ai/llms.txt
> Use this file to discover all available pages before exploring further.
# Get Main Table Data V2
Post/api/v1/demand-gen/new-table
Returns main table data based on filter criteria with pagination (Version 2)
Header parametersauthtokenstring
Auth Token
Query parameterspageinteger (int32)
Page number
Example0
sizeinteger (int32)
Page size
Example10
Body parameters
Demand gen Payload
Demand gen Payload Example
Demand gen Payload Example
```json
{
"oppAttribution": "primaryContact",
"attributionType": "firstTouch",
"staticCampaignFilter": true,
"firstTimeCreated": true,
"dateFilter": "previous365Day"
}
```
Expand Allobject filterobject
Map of selected filters
property*object (SelectedFilter) additionalProperties
Map of selected filters
typestring Valid values[
"INTEGER",
"LONG",
"DECIMAL",
"FLOAT",
"DOUBLE",
"BOOLEAN",
"STRING",
"TIMESTAMP",
"DATE",
"AGGREGATE",
"ARRAYSTRING"
]
containsboolean
operatorstring
values Array of string string
permissionFilterboolean
implicitboolean
customFilterboolean
children Array of object (SelectedFilter) object Recursive
Map of selected filters
emptyboolean
dateFilterstring
Date range for analysing data
ExamplelastYear
dateGroupstring
Grouping for date data
Examplemonth
funnelViewstring
View type for funnel data
Examplevolume
funnelTypestring
Type of funnel analysis
Examplesnapshot
funnelSplitBystring
Dimension to split funnel data by
funnelQuarterstring
Quarter selection for funnel analysis
Examplequarter1
funnelComparisonTypestring
Type of comparison for funnel analysis
closingTimestring
Time period for closing analysis
ExampleanyTime
startDatestring
Start date for date range
endDatestring
End date for date range
compareOnstring
Dimension to compare data on
isCustomboolean
Flag indicating if custom date range is used
Examplefalse
funnelCorrelateBystring
Dimension to correlate funnel data by
cohortInitialStagestring
Initial stage for cohort analysis
cohortScopestring
Scope for cohort analysis
Examplestart
overlayWithstring
Dimension to overlay data with
snapshotAsOnstring
Date for snapshot analysis
conversionRatioboolean
Flag to enable conversion ratio calculation
topCompositions Array of string
List of top compositions to analyze
string
List of top compositions to analyze
segmentstring
Segment for data analysis
attributionTypestring
Type of attribution model
ExamplefirstTouch
selectedValues Array of object (SelectedStage)
List of selected stage values
object
List of selected stage values
keystring
titlestring
valuestring
entitystring
entryStageboolean
Flag indicating if this is an entry stage
insightStagestring
Stage for insight analysis
conditionstring
Condition for insight analysis
columnstring
Column dimension ID
orderBystring
Field to order results by
trendOrderBySelectstring
Field to order trend results by
enableStateboolean
Flag to enable state filtering
Examplefalse
topXstring
Number of top records to return
Exampletop100
stagestring
Selected stage for analysis
statestring
Selected state for analysis
endStagestring
End stage for analysis
endStatestring
End state for analysis
metrics Array of string
List of metrics to analyze
string
List of metrics to analyze
metricGroups Array of string
List of metric groups to analyze
string
List of metric groups to analyze
stageEntitystring
Entity type for stage analysis
sourceStageEntitystring
Source entity type for stage analysis
firstTimeCreatedboolean
Flag indicating if this is the first time the filter is created
dateFilterDimensionstring
Dimension for date filtering
createdQuarter Array of string
List of quarters for creation date filtering
string
List of quarters for creation date filtering
includeSplitboolean
Flag to include split in results
impliedFunnelboolean
Flag indicating if funnel is implied
Examplefalse
openAsOnstring
Date for open-as-on analysis
dateViewstring
View type for date data
ExampleCREATED
cohortStartStages Array of object (CohortStartStages)
List of start stages for cohort analysis
object
List of start stages for cohort analysis
titlestring
valuestring
keystring
entitystring
viewTypestring
Group of metrics for view
Valid values[
"Open",
"PROGRESSION_FROM_STAGE",
"PROGRESSION_TO_STAGE",
"PROGRESSION",
"Leakage",
"Generated",
"DIRECT_GENERATED",
"Influenced",
"Regression",
"Projected",
"Other",
"Conversion"
]
logQueryboolean
Flag to enable query logging
Examplefalse
columns Array of string
List of columns to include in results
string
List of columns to include in results
cohortStartStagestring
Start stage for cohort analysis
cohortStartStatestring
Start state for cohort analysis
progressedStagesobject
Map of stages that have progressed
property* Array of string additionalProperties
Map of stages that have progressed
string
Map of stages that have progressed
progressedStagesBackendobject
Backend map of stages that have progressed
property* Array of string additionalProperties
Backend map of stages that have progressed
string
Backend map of stages that have progressed
progressedPeriodstring
Time period for progression analysis
ExamplelastYear
progressedStartDatestring
Start date for progression analysis
progressedEndDatestring
End date for progression analysis
trendStartDatestring
Start date for trend analysis
trendEndDatestring
End date for trend analysis
metricstring
Metric for analysis
ExampleopenVolume
numRecordinteger (int32)
Number of records to return
orderstring
Sort order for results
Examplehighest
analysisTypestring
Type of analysis to perform
funnelStagesobject
Map of funnel stages to states
property* Array of string additionalProperties
Map of funnel stages to states
string
Map of funnel stages to states
parentTabstring
Parent tab for UI
Examplefunnel
stageProgressions Array of object (StageProgression)
List of stage progressions
object
List of stage progressions
startStagestring
startStatestring
endStagestring
endState Array of string string
querystring
keystring
chiSquareEnabledboolean
Flag to enable chi-square analysis
smartFilterobject (Node)
Smart filter node for complex filtering
cohortStartDatestring
Start date for cohort analysis
cohortEndDatestring
End date for cohort analysis
stages Array of string
List of stages for analysis
string
List of stages for analysis
splitValues Array of string
List of values to split data by
string
List of values to split data by
pageCategorystring
Category of page for UI context
Valid values[
"HOME_PAGE",
"PIPELINE_PROJECTION",
"SNAPSHOT",
"COHORT",
"DEMAND_GEN",
"LEAD_PRIORITIZATION",
"OPP_PRIORITIZATION",
"ACCOUNT_PRIORITIZATION",
"MULTITOUCH",
"MARKETING_EFFECTIVENESS",
"ATTRIBUTION_COMPARISON",
"GENERATION_ATTRIBUTION",
"LEAKAGE_ATTRIBUTION",
"RECOMMENDATION_ANALYTICS",
"CAMPAIGN_REALLOCATION",
"USERS_GROUPS",
"PIPELINE_HEALTH",
"PIPELINE_ANALYTICS",
"JOURNEY",
"UFP_INSIGHT",
"PIPELINE_MOVEMENTS",
"FUNNEL_HEALTH",
"MARKETING_PERFORMANCE",
"MARKETING_MIX",
"DATA_VALIDATION",
"CAMP_LIFT_ANALYSIS",
"RECORD_LIST"
]
quarters Array of string
List of quarters for analysis
string
List of quarters for analysis
debugModeboolean
Flag to enable debug mode
summaryMetricstring
Metric for summary analysis
compareWithstring
Period to compare with
ExamplelastWeek
selectionTypestring
Type of selection
ExamplestagesSelected
dgeCohortRequestboolean
Flag for demand generation cohort request
Examplefalse
includeTrendsboolean
Flag to include trends in results
exportContextobject (ExportContext)
Context for data export
viewIdstring
viewNamestring
pagestring
requestedAtinteger (int64)
requestedAtStrstring
pageNamestring
urlstring
marketingSourcedQueryboolean
Flag for marketing sourced queries
cumulativeAttainmentboolean
Flag for cumulative attainment calculation
chartViewstring
View type for charts
cohortTrendAsOnstring
Date for cohort trend analysis
configIdstring
ID of the configuration
secondaryStartDatestring
Secondary start date for comparison
secondaryEndDatestring
Secondary end date for comparison
secondaryMetricstring
Secondary metric for comparison
controlValuestring
Value for control group
viewTrendsstring
Type of trend view
groupByobject
Map of dimensions to group results by
property* Array of string additionalProperties
Map of dimensions to group results by
string
Map of dimensions to group results by
accountStagestring
Stage for account analysis
accountStageValuestring
Value of account stage
entityIdstring
ID of the entity
allowFutureDateboolean
Flag to allow future dates in date ranges
recordListRequestboolean
Flag for record list requests
recordListIdstring
ID of the record list
applyLimitboolean
Flag to apply limit to query results
Exampletrue
pageRequestobject (PageRequestObject)
Pagination and sorting parameters
ExamplePageRequest.of(0, 10, Sort.by("CampaignName"))sortobject (Sort) emptyboolean
sortedboolean
unsortedboolean
offsetinteger (int64)
pageNumberinteger (int32)
pageSizeinteger (int32)
pagedboolean
unpagedboolean
includeColumns Array of string
Dimensions and Metrics to include in request
Example[
"CampaignType",
"CampaignName",
"generatedLeadVolume"
]string
Dimensions and Metrics to include in request
Example["CampaignType","CampaignName","generatedLeadVolume"]
includeMetrics Array of string
Metrics to include in the request
Example[
"generatedLeadVolume",
"generatedLeadValue"
]string
Metrics to include in the request
Example["generatedLeadVolume","generatedLeadValue"]
queriesobject
Query parameters for filtering data
Example{
"CampaignType": "Email",
"CampaignName": "Q1 Campaign"
}property*string additionalProperties
Query parameters for filtering data
Example{"CampaignType":"Email","CampaignName":"Q1 Campaign"}
campaignDateColstring
Column name for campaign date filtering
ExampleCampaignStartDate
topinteger (int32)
Number of top records to return
Example10
sortOrderstring
Sort order for the results
Valid values[
"HIGHEST",
"LOWEST"
]ExampleASC or DESC
orderByMetricstring
Metric name to order results by
ExamplegeneratedLeadVolume
funnelSnapshotboolean
Flag to indicate if funnel snapshot is required
Exampletrue
sideTableTabstring
Tab name for side table
Examplesummary
campaignDateFilterstring
Predefined time period for campaign date filtering
ExamplelastYear
campaignStartDatestring
Start date for campaign date range filter
Example2023-01-01
campaignEndDatestring
End date for campaign date range filter
Example2023-12-31
campaignMetricDateFilterstring
Predefined time period for campaign metric date filtering
ExamplelastYear
campaignMetricStartDatestring
Start date for campaign metric date range filter
Example2023-01-01
campaignMetricEndDatestring
End date for campaign metric date range filter
Example2023-12-31
campMemberEngDateFilterstring
Predefined time period for campaign member engagement date filtering
ExamplelastYear
campMemberEngStartDatestring
Start date for campaign member engagement date range filter
Example2023-01-01
campMemberEngEndDatestring
End date for campaign member engagement date range filter
Example2023-12-31
leadLookBackWindowinteger (int32)
Look back window in days for lead metrics
Example30
oppLookBackWindowinteger (int32)
Look back window in days for opportunity metrics
Example90
secondCallboolean
Flag to indicate if this is a second API call
Examplefalse
thirdCallboolean
Flag to indicate if this is a third API call
Examplefalse
controlsobject (DGControls)
Demand generation control parameters
trendobject (TrendControl) enabledboolean
metricstring
viewBystring
funnelobject (FunnelControls) enabledboolean
metricstring
colorCodeobject (ColorCodeControls) enabledboolean
metric Array of string string
waterfallobject (WaterfallControls) enabledboolean
stagestring
metricstring
viewstring
viewBystring
growthobject (GrowthControls) enabledboolean
metric Array of string string
viewBystring
growthTypestring
wowMetrics Array of string
Week over week metrics to include
Example[
"generatedLeadVolume",
"generatedLeadValue"
]string
Week over week metrics to include
Example["generatedLeadVolume","generatedLeadValue"]
metricCategorystring
Category of metrics to include
Examplevolume
leakedTimePeriodstring
Predefined time period for leaked metrics
ExamplelastYear
leakedStartDatestring
Start date for leaked metrics date range
Example2023-01-01
leakedEndDatestring
End date for leaked metrics date range
Example2023-12-31
reallocationLogicstring
Logic for budget reallocation
Exampleproportional
topCampaignNuminteger (int32)
Number of top campaigns to consider for reallocation
Example5
bottomCampaignNuminteger (int32)
Number of bottom campaigns to consider for reallocation
Example5
reallocationCriteriastring
Criteria for budget reallocation
Exampleperformance
testboolean
Flag to indicate if this is a test request
Examplefalse
keyMetricRequestboolean
Flag to indicate if only key metrics are requested
Exampletrue
skipNullSpendboolean
Flag to skip campaigns with null spend
Exampletrue
implicitSpendSortingEnabledboolean
Flag to enable implicit sorting by spend
Exampletrue
staticCampaignFilterboolean
Flag to use static campaign filters
Examplefalse
topSortboolean
Flag to sort by top values
Exampletrue
metricTrendSplitstring
Split type for metric trends
Examplemonthly
metricTrendCampaignNamestring
Campaign name for metric trend analysis
ExampleQ1 Email Campaign
metricTrendIsCumulativeboolean
Flag to indicate if metric trend is cumulative
Examplefalse
stageDGEstring
Stage for demand generation engine
Examplelead
trendCountinteger (int32)
Maximum number of trend data points to return
Example12
attrMetricStoreColumnstring
Column name for attribution metric store
ExampleattributionModel
oppAttributionstring
Opportunity attribution model
ExamplefirstTouch
contributionTypestring
Type of contribution analysis
Exampledirect
engagementFiltersobject (JourneyFilter) filterobject
Map of selected filters
property*object (SelectedFilter) additionalProperties
Map of selected filters
typestring Valid values[
"INTEGER",
"LONG",
"DECIMAL",
"FLOAT",
"DOUBLE",
"BOOLEAN",
"STRING",
"TIMESTAMP",
"DATE",
"AGGREGATE",
"ARRAYSTRING"
]
containsboolean
operatorstring
values Array of string string
permissionFilterboolean
implicitboolean
customFilterboolean
children Array of object (SelectedFilter) object Recursive
Map of selected filters
emptyboolean
dateFilterstring
Date range for analysing data
ExamplelastYear
dateGroupstring
Grouping for date data
Examplemonth
funnelViewstring
View type for funnel data
Examplevolume
funnelTypestring
Type of funnel analysis
Examplesnapshot
funnelSplitBystring
Dimension to split funnel data by
funnelQuarterstring
Quarter selection for funnel analysis
Examplequarter1
funnelComparisonTypestring
Type of comparison for funnel analysis
closingTimestring
Time period for closing analysis
ExampleanyTime
startDatestring
Start date for date range
endDatestring
End date for date range
compareOnstring
Dimension to compare data on
isCustomboolean
Flag indicating if custom date range is used
Examplefalse
funnelCorrelateBystring
Dimension to correlate funnel data by
cohortInitialStagestring
Initial stage for cohort analysis
cohortScopestring
Scope for cohort analysis
Examplestart
overlayWithstring
Dimension to overlay data with
snapshotAsOnstring
Date for snapshot analysis
conversionRatioboolean
Flag to enable conversion ratio calculation
topCompositions Array of string
List of top compositions to analyze
string
List of top compositions to analyze
segmentstring
Segment for data analysis
attributionTypestring
Type of attribution model
ExamplefirstTouch
selectedValues Array of object (SelectedStage)
List of selected stage values
object
List of selected stage values
keystring
titlestring
valuestring
entitystring
entryStageboolean
Flag indicating if this is an entry stage
insightStagestring
Stage for insight analysis
conditionstring
Condition for insight analysis
columnstring
Column dimension ID
orderBystring
Field to order results by
trendOrderBySelectstring
Field to order trend results by
enableStateboolean
Flag to enable state filtering
Examplefalse
topXstring
Number of top records to return
Exampletop100
stagestring
Selected stage for analysis
statestring
Selected state for analysis
endStagestring
End stage for analysis
endStatestring
End state for analysis
metrics Array of string
List of metrics to analyze
string
List of metrics to analyze
metricGroups Array of string
List of metric groups to analyze
string
List of metric groups to analyze
stageEntitystring
Entity type for stage analysis
sourceStageEntitystring
Source entity type for stage analysis
firstTimeCreatedboolean
Flag indicating if this is the first time the filter is created
dateFilterDimensionstring
Dimension for date filtering
createdQuarter Array of string
List of quarters for creation date filtering
string
List of quarters for creation date filtering
includeSplitboolean
Flag to include split in results
impliedFunnelboolean
Flag indicating if funnel is implied
Examplefalse
openAsOnstring
Date for open-as-on analysis
dateViewstring
View type for date data
ExampleCREATED
cohortStartStages Array of object (CohortStartStages)
List of start stages for cohort analysis
object
List of start stages for cohort analysis
titlestring
valuestring
keystring
entitystring
viewTypestring
Group of metrics for view
Valid values[
"Open",
"PROGRESSION_FROM_STAGE",
"PROGRESSION_TO_STAGE",
"PROGRESSION",
"Leakage",
"Generated",
"DIRECT_GENERATED",
"Influenced",
"Regression",
"Projected",
"Other",
"Conversion"
]
logQueryboolean
Flag to enable query logging
Examplefalse
columns Array of string
List of columns to include in results
string
List of columns to include in results
cohortStartStagestring
Start stage for cohort analysis
cohortStartStatestring
Start state for cohort analysis
progressedStagesobject
Map of stages that have progressed
property* Array of string additionalProperties
Map of stages that have progressed
string
Map of stages that have progressed
progressedStagesBackendobject
Backend map of stages that have progressed
property* Array of string additionalProperties
Backend map of stages that have progressed
string
Backend map of stages that have progressed
progressedPeriodstring
Time period for progression analysis
ExamplelastYear
progressedStartDatestring
Start date for progression analysis
progressedEndDatestring
End date for progression analysis
trendStartDatestring
Start date for trend analysis
trendEndDatestring
End date for trend analysis
metricstring
Metric for analysis
ExampleopenVolume
numRecordinteger (int32)
Number of records to return
orderstring
Sort order for results
Examplehighest
analysisTypestring
Type of analysis to perform
funnelStagesobject
Map of funnel stages to states
property* Array of string additionalProperties
Map of funnel stages to states
string
Map of funnel stages to states
parentTabstring
Parent tab for UI
Examplefunnel
stageProgressions Array of object (StageProgression)
List of stage progressions
object
List of stage progressions
startStagestring
startStatestring
endStagestring
endState Array of string string
querystring
keystring
chiSquareEnabledboolean
Flag to enable chi-square analysis
smartFilterobject (Node)
Smart filter node for complex filtering
cohortStartDatestring
Start date for cohort analysis
cohortEndDatestring
End date for cohort analysis
stages Array of string
List of stages for analysis
string
List of stages for analysis
splitValues Array of string
List of values to split data by
string
List of values to split data by
pageCategorystring
Category of page for UI context
Valid values[
"HOME_PAGE",
"PIPELINE_PROJECTION",
"SNAPSHOT",
"COHORT",
"DEMAND_GEN",
"LEAD_PRIORITIZATION",
"OPP_PRIORITIZATION",
"ACCOUNT_PRIORITIZATION",
"MULTITOUCH",
"MARKETING_EFFECTIVENESS",
"ATTRIBUTION_COMPARISON",
"GENERATION_ATTRIBUTION",
"LEAKAGE_ATTRIBUTION",
"RECOMMENDATION_ANALYTICS",
"CAMPAIGN_REALLOCATION",
"USERS_GROUPS",
"PIPELINE_HEALTH",
"PIPELINE_ANALYTICS",
"JOURNEY",
"UFP_INSIGHT",
"PIPELINE_MOVEMENTS",
"FUNNEL_HEALTH",
"MARKETING_PERFORMANCE",
"MARKETING_MIX",
"DATA_VALIDATION",
"CAMP_LIFT_ANALYSIS",
"RECORD_LIST"
]
quarters Array of string
List of quarters for analysis
string
List of quarters for analysis
debugModeboolean
Flag to enable debug mode
summaryMetricstring
Metric for summary analysis
compareWithstring
Period to compare with
ExamplelastWeek
selectionTypestring
Type of selection
ExamplestagesSelected
dgeCohortRequestboolean
Flag for demand generation cohort request
Examplefalse
includeTrendsboolean
Flag to include trends in results
exportContextobject (ExportContext)
Context for data export
viewIdstring
viewNamestring
pagestring
requestedAtinteger (int64)
requestedAtStrstring
pageNamestring
urlstring
marketingSourcedQueryboolean
Flag for marketing sourced queries
cumulativeAttainmentboolean
Flag for cumulative attainment calculation
chartViewstring
View type for charts
cohortTrendAsOnstring
Date for cohort trend analysis
configIdstring
ID of the configuration
secondaryStartDatestring
Secondary start date for comparison
secondaryEndDatestring
Secondary end date for comparison
secondaryMetricstring
Secondary metric for comparison
controlValuestring
Value for control group
viewTrendsstring
Type of trend view
groupByobject
Map of dimensions to group results by
property* Array of string additionalProperties
Map of dimensions to group results by
string
Map of dimensions to group results by
accountStagestring
Stage for account analysis
accountStageValuestring
Value of account stage
entityIdstring
ID of the entity
allowFutureDateboolean
Flag to allow future dates in date ranges
recordListRequestboolean
Flag for record list requests
recordListIdstring
ID of the record list
applyLimitboolean
Flag to apply limit to query results
Exampletrue
journeyForstring
journeyAnalysisTypestring
createdStagestring
progressedDateFilterstring
progressedStagestring
topinteger (int32)
engagements Array of string string
source Array of string string
engagementModestring
journeystring
startWith Array of string string
endWith Array of string string
hasAny Array of string string
journeysBystring
touchPointstring
funnelContextobject (FunnelContext) sourcestring Valid values[
"STANDARD",
"CUSTOM"
]
funnelConfigTypestring
forTouchPointboolean
sequenceFilterobject (SequenceFilter) logicalOperatorstring Valid values[
"AND",
"OR",
"IF",
"ELSEIF",
"ELSE"
]
sequence Array of object (Sequence) object immediateboolean
sequenceList Array of string string
sequenceQuerystring
touchPointSequenceQuerystring
engagementPeriodstring
smartFilterPresentboolean
engagementTypestring
engagementBystring
touchPointConsideredstring
engagementTypes Array of string string
engagementChannels Array of string string
pageType Array of string string
engagementDesc Array of string string
engagementDatestring
engagementFromDatestring
engagementEndDatestring
campaignStartDatestring
campaignFromDatestring
campaignEndDatestring
recordListobject (RecordList)
Record list configuration for data retrieval
createdBystring
modifiedBystring
createdAtinteger (int64)
modifiedAtinteger (int64)
deletedboolean
idstring
tenantIdstring
namestring
descriptionstring
recordTypestring Valid values[
"Lead",
"Opportunity",
"Account"
]
creationTypestring Valid values[
"Static",
"Dynamic"
]
viewIdstring
viewNamestring
pathstring
pathDetailstring
modulestring
countinteger (int32)
stagestring
configobject property*object additionalProperties
filePathstring
querystring
stageRangeobject (StageRange)
Range of stages for analysis
startStagestring
endStagestring
overallRowNumboolean
Flag to include overall row numbers
Examplefalse
postPipelineBookingboolean
Flag to include post-pipeline booking metrics
Exampletrue
postOppInfMetricsboolean
Flag to include post-opportunity influenced metrics
Exampletrue
preOppMetricsboolean
Flag to include pre-opportunity metrics
Exampletrue
allKeyMetricsboolean
Flag to include all key metrics
Exampletrue
recordListobject (RecordList)
Record list configuration for data retrieval
createdBystring
modifiedBystring
createdAtinteger (int64)
modifiedAtinteger (int64)
deletedboolean
idstring
tenantIdstring
namestring
descriptionstring
recordTypestring Valid values[
"Lead",
"Opportunity",
"Account"
]
creationTypestring Valid values[
"Static",
"Dynamic"
]
viewIdstring
viewNamestring
pathstring
pathDetailstring
modulestring
countinteger (int32)
stagestring
configobject property*object additionalProperties
filePathstring
querystring
stageRangeobject (StageRange)
Range of stages for analysis
startStagestring
endStagestring
Responses200
OK
Expand Allobject resultboolean
cachedDataboolean
requestIdstring
dataobject
messagestring
errorCodestring
errorMessagestring
metadataobject property*object additionalProperties