Share
Explore
Draft Coda Schema
Building schemas can be a nightmare - No longer! Just input your JSON below watch the magic happen.
Magic not working for you yet?
Reset Page
Call my schema:
Example JSON object
Copy/paste the example JSON object you want a Coda Schema for
{
"id": 3638,
"title": "Coda Test",
"name": "Coda Test",
"clientName": "theshelf.com",
"clientUrl": "http://theshelf.com",
"creatorUser": 5192399,
"createdDate": "2024-09-19T12:18:16.576821",
"dateStart": null,
"dateEnd": null,
"isPreOutreach": false,
"profileImgUrl": null,
"numInfluencers": null,
"numPosts": null,
"reportPageUrl": "/campaigns/3638/report/",
"settingsPageUrl": "/campaigns/3638/settings/",
"clientDashboardUrl": "/client_dashboard/313191/3638/5192399/9fba4ac17ed0c0623bcd4d92e1ee635f/",
"deckEditPage": "/client_dashboard/client_reporting/influencers_deck/313191/3638/5192399/9fba4ac17ed0c0623bcd4d92e1ee635f/",
"deckClientViewPage": "/client_dashboard/view_campaign_reporting_deck/313191/3638/5192399/9fba4ac17ed0c0623bcd4d92e1ee635f/#/client",
"deckCaseStudyViewPage": "/client_dashboard/view_campaign_reporting_deck/313191/3638/5192399/9fba4ac17ed0c0623bcd4d92e1ee635f/#/case_study",
"pipelinePageUrl": "/campaigns/3638/setup/",
"archived": false,
"managementSettings": {
"id": 1999,
"owner": 126,
"participants": [],
"totalBudget": 0.0,
"maxInfluencerBudget": 0.0,
"estimatedMaxInfluencerBudget": 0.0,
"activityStatus": null,
"healthStatus": null,
"campaignType": null,
"reportDueDate": null,
"kpiReportingEnabled": null,
"googleCalendarUrl": null
},
"userSettings": {
"id": 3474,
"campaign": 3638,
"isInfluencerApprovalEnabled": false,
"isPostApprovalEnabled": false,
"isContractEnabled": false,
"isTrackingCodeEnabled": false,
"isPaymentSystemEnabled": false,
"isPerPostTrackingEnabled": true,
"shouldCollectShippingAddress": true,
"shouldCollectProductPreferences": true,
"useLatestSetup": false,
"useGoogleDocContractSetup": true,
"useLatestInfluencerApprovalNamingConvention": true,
"usePostDraftsUiV2": null,
"useNewPipelineSetup": true,
"coverImageBlurEnabled": true,
"slackChannels": []
},
"clientSettings": {
"id": 3409,
"campaign": 3638,
"logoImgUrl": null,
"logoBackgroundColor": null,
"slidesDeckTagsFilteringEnabled": false,
"slidesDeckFilterTagTypes": [],
"useCustomLogo": null,
"influencerApprovalUiVersion": 1
},
"denormValues": null,
"realCampaign": null,
"influencerAnalyticsCollection": {
"id": 5126,
"approvalStatus": 0,
"isUpdating": false,
"systemCollection": false
},
"rootGoogleDriveFolder": null,
"googleCalendarUrl": null,
"isMultiApprovalSetupEnabled": false
}
1 of 1
⚠️ Input schema name at top ⚠️
Generate Sync Table Schema
Generate Object Schema
All schemas generated (50)
50
View Schema
Schema
Modify
Copy
Delete
Example Schema
1
const sch_campaigns = coda.makeObjectSchema({. . .
const sch_campaigns = coda.makeObjectSchema({
properties: {
id: {type: coda.ValueType.Number},
title: {type: coda.ValueType.String},
name: {type: coda.ValueType.String},
clientName: {type: coda.ValueType.String},
clientUrl: {type: coda.ValueType.String},
creatorUser: {type: coda.ValueType.Number},
createdDate: {type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime},
dateStart: {type: coda.ValueType.String},
dateEnd: {type: coda.ValueType.String},
isPreOutreach: {type: coda.ValueType.Boolean},
profileImgUrl: {type: coda.ValueType.String},
numInfluencers: {type: coda.ValueType.Number},
numPosts: {type: coda.ValueType.Number},
reportPageUrl: {type: coda.ValueType.String},
settingsPageUrl: {type: coda.ValueType.String},
clientDashboardUrl: {type: coda.ValueType.String},
deckEditPage: {type: coda.ValueType.String},
deckClientViewPage: {type: coda.ValueType.String},
deckCaseStudyViewPage: {type: coda.ValueType.String},
pipelinePageUrl: {type: coda.ValueType.String},
archived: {type: coda.ValueType.Boolean},
managementSettings: coda.makeObjectSchema({
properties: {
id: {type: coda.ValueType.Number},
owner: {type: coda.ValueType.Number},
participants: {type: coda.ValueType.Array, items: {type: coda.ValueType.Any}},
totalBudget: {type: coda.ValueType.Number},
maxInfluencerBudget: {type: coda.ValueType.Number},
estimatedMaxInfluencerBudget: {type: coda.ValueType.Number},
activityStatus: {type: coda.ValueType.String},
healthStatus: {type: coda.ValueType.String},
campaignType: {type: coda.ValueType.String},
reportDueDate: {type: coda.ValueType.String},
kpiReportingEnabled: {type: coda.ValueType.String},
googleCalendarUrl: {type: coda.ValueType.String}
}
}),
userSettings: coda.makeObjectSchema({
properties: {
id: {type: coda.ValueType.Number},
campaign: {type: coda.ValueType.Number},
isInfluencerApprovalEnabled: {type: coda.ValueType.Boolean},
isPostApprovalEnabled: {type: coda.ValueType.Boolean},
isContractEnabled: {type: coda.ValueType.Boolean},
isTrackingCodeEnabled: {type: coda.ValueType.Boolean},
isPaymentSystemEnabled: {type: coda.ValueType.Boolean},
isPerPostTrackingEnabled: {type: coda.ValueType.Boolean},
shouldCollectShippingAddress: {type: coda.ValueType.Boolean},
shouldCollectProductPreferences: {type: coda.ValueType.Boolean},
useLatestSetup: {type: coda.ValueType.Boolean},
useGoogleDocContractSetup: {type: coda.ValueType.Boolean},
useLatestInfluencerApprovalNamingConvention: {type: coda.ValueType.Boolean},
usePostDraftsUiV2: {type: coda.ValueType.Any},
useNewPipelineSetup: {type: coda.ValueType.Boolean},
coverImageBlurEnabled: {type: coda.ValueType.Boolean},
slackChannels: {type: coda.ValueType.Array, items: {type: coda.ValueType.Any}}
}
}),
clientSettings: coda.makeObjectSchema({
properties: {
id: {type: coda.ValueType.Number},
campaign: {type: coda.ValueType.Number},
logoImgUrl: {type: coda.ValueType.String},
logoBackgroundColor: {type: coda.ValueType.String},
slidesDeckTagsFilteringEnabled: {type: coda.ValueType.Boolean},
slidesDeckFilterTagTypes: {type: coda.ValueType.Array, items: {type: coda.ValueType.Any}},
useCustomLogo: {type: coda.ValueType.Any},
influencerApprovalUiVersion: {type: coda.ValueType.Number}
}
}),
denormValues: {type: coda.ValueType.Any},
realCampaign: {type: coda.ValueType.Any},
influencerAnalyticsCollection: coda.makeObjectSchema({
properties: {
id: {type: coda.ValueType.Number},
approvalStatus: {type: coda.ValueType.Number},
isUpdating: {type: coda.ValueType.Boolean},
systemCollection: {type: coda.ValueType.Boolean}
}
}),
rootGoogleDriveFolder: {type: coda.ValueType.Any},
googleCalendarUrl: {type: coda.ValueType.String},
isMultiApprovalSetupEnabled: {type: coda.ValueType.Boolean}
},
displayProperty: "name",
idProperty: "createdDate",
featuredProperties: ["id", "title", "name", "clientName", "clientUrl", "creatorUser", "createdDate", "isPreOutreach", "profileImgUrl", "numInfluencers", "numPosts", "reportPageUrl", "settingsPageUrl", "clientDashboardUrl", "deckEditPage", "deckClientViewPage", "deckCaseStudyViewPage", "pipelinePageUrl", "archived"]
})
2
const sch_product = coda.makeObjectSchema({. . .
const sch_product = coda.makeObjectSchema({
properties: {
id: { type: coda.ValueType.String },
title: { type: coda.ValueType.String },
lender_note: { type: coda.ValueType.String },
url: { type: coda.ValueType.String },
retail_price: { type: coda.ValueType.Number },
base_price: { type: coda.ValueType.Number },
cleaning_fee: { type: coda.ValueType.Number },
discount: { type: coda.ValueType.Number },
lender_id: { type: coda.ValueType.String },
size_id: { type: coda.ValueType.String },
length_id: { type: coda.ValueType.String },
sleeve_id: { type: coda.ValueType.String },
cut_id: { type: coda.ValueType.String },
brand: { type: coda.ValueType.String },
images: {
type: coda.ValueType.Array,
items: { type: coda.ValueType.String }
},
primary_image: { type: coda.ValueType.String },
updated_at: { type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime },
created_at: { type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime },
price_range: { type: coda.ValueType.String },
status: { type: coda.ValueType.String },
temp_collections: { type: coda.ValueType.String }
},
displayProperty: "title",
idProperty: "id",
featuredProperties: ["id", "title", "lender_note", "url", "retail_price", "base_price", "cleaning_fee", "discount", "lender_id", "size_id", "length_id", "sleeve_id", "cut_id", "brand", "images", "primary_image", "updated_at", "created_at", "price_range", "status", "temp_collections"]
});
3
const sch_post_type = coda.makeObjectSchema({. . .
const sch_post_type = coda.makeObjectSchema({
properties: {
id: { type: coda.ValueType.Number },
platformName: { type: coda.ValueType.String },
verboseShort: { type: coda.ValueType.String },
verbose: { type: coda.ValueType.String },
uiName: { type: coda.ValueType.String },
verboseContentType: { type: coda.ValueType.String },
isMultipart: { type: coda.ValueType.Boolean },
postContentPartName: { type: coda.ValueType.String },
artificialPostsOnly: { type: coda.ValueType.Boolean },
ocrMetricsModel: { type: coda.ValueType.String },
defaultPostSubType: { type: coda.ValueType.String },
archived: { type: coda.ValueType.Boolean }
},
displayProperty: "platformName",
idProperty: "id",
featuredProperties: ["id", "platformName", "verboseShort", "verbose", "uiName", "verboseContentType", "isMultipart", "postContentPartName", "artificialPostsOnly", "ocrMetricsModel", "defaultPostSubType", "archived"]
});
4
const sch_example = coda.makeObjectSchema({. . .
const sch_example = coda.makeObjectSchema({
properties: {
allowMultipleTags: { type: coda.ValueType.Boolean },
contentType: { type: coda.ValueType.Number },
name: { type: coda.ValueType.String },
tagNames: { type: coda.ValueType.Array, items: { type: coda.ValueType.String } }
},
displayProperty: "name",
idProperty: "name",
featuredProperties: ["allowMultipleTags", "contentType", "name", "tagNames"]
});
5
const sch_facebookads = coda.makeObjectSchema({. . .
const sch_facebookads = coda.makeObjectSchema({
properties: {
id: { type: coda.ValueType.String },
adSet: { type: coda.ValueType.String },
creative: { type: coda.ValueType.String },
postReport: { type: coda.ValueType.Number },
insights: { type: coda.ValueType.Object },
name: { type: coda.ValueType.String },
createdTime: { type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime },
updatedTime: { type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime },
parsedAdName: coda.makeObjectSchema({
properties: {
username: { type: coda.ValueType.String },
postTypeVerbose: { type: coda.ValueType.String },
videoDuration: { type: coda.ValueType.Number },
campaignTitle: { type: coda.ValueType.String }
},
displayProperty: "username”
}),
organicPostConnectionFailureReason: { type: coda.ValueType.Object },
correctedNameForParsing: { type: coda.ValueType.Object },
rawData: coda.makeObjectSchema({
properties: {
id: { type: coda.ValueType.String },
name: { type: coda.ValueType.String },
status: { type: coda.ValueType.String },
adsetId: { type: coda.ValueType.String },
bidType: { type: coda.ValueType.String },
creative: coda.makeObjectSchema({
properties: {
id: { type: coda.ValueType.String }
},
displayProperty: "id”
}),
targeting: coda.makeObjectSchema({
properties: {
ageMax: { type: coda.ValueType.Number },
ageMin: { type: coda.ValueType.Number },
geoLocations: coda.makeObjectSchema({
properties: {
countries: { type: coda.ValueType.Array, items: { type: coda.ValueType.String } },
locationTypes: { type: coda.ValueType.Array, items: { type: coda.ValueType.String } }
}
}),
customAudiences: { type: coda.ValueType.Array, items: coda.makeObjectSchema({
properties: {
id: { type: coda.ValueType.String },
name: { type: coda.ValueType.String }
}
}) },
targetingRelaxationTypes: coda.makeObjectSchema({
properties: {
lookalike: { type: coda.ValueType.Number },
customAudience: { type: coda.ValueType.Number }
}
}),
brandSafetyContentFilterLevels: { type: coda.ValueType.Array, items: { type: coda.ValueType.String } }
}
}),
accountId: { type: coda.ValueType.String },
campaignId: { type: coda.ValueType.String },
createdTime: { type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime },
sourceAdId: { type: coda.ValueType.String },
updatedTime: { type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime },
demolinkHash: { type: coda.ValueType.String },
adActiveTime: { type: coda.ValueType.String },
trackingSpecs: { type: coda.ValueType.Array, items: coda.makeObjectSchema({
properties: {
fbPixel: { type: coda.ValueType.Array, items: { type: coda.ValueType.String } },
"action.type": { type: coda.ValueType.Array, items: { type: coda.ValueType.String } },
conversionId: { type: coda.ValueType.Array, items: { type: coda.ValueType.String } }
}
}) },
displaySequence: { type: coda.ValueType.Number },
effectiveStatus: { type: coda.ValueType.String },
engagementAudience: { type: coda.ValueType.Boolean },
previewShareableLink: { type: coda.ValueType.String }
},
displayProperty: "id”
})
},
displayProperty: "name",
idProperty: "createdTime",
featuredProperties: ["id", "adSet", "creative", "postReport", "insights", "name", "createdTime", "updatedTime", "parsedAdName", "organicPostConnectionFailureReason", "correctedNameForParsing", "rawData"]
});
6
const schema_envelope_templates = coda.makeObjectSchema({. . .
const schema_envelope_templates = coda.makeObjectSchema({
properties: {
templateId: {type: coda.ValueType.String},
uri: {type: coda.ValueType.String},
name: {type: coda.ValueType.String},
shared: {type: coda.ValueType.String},
passwordProtected: {type: coda.ValueType.String},
description: {type: coda.ValueType.String},
created: {type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime},
lastModified: {type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime},
lastUsed: {type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime},
owner: coda.makeObjectSchema({
properties: {
userName: {type: coda.ValueType.String},
userId: {type: coda.ValueType.String},
email: {type: coda.ValueType.String}
},
displayProperty: "userName”
}),
pageCount: {type: coda.ValueType.String},
folderId: {type: coda.ValueType.String},
folderName: {type: coda.ValueType.String},
folderIds: {type: coda.ValueType.Array, items: {type: coda.ValueType.String}},
autoMatch: {type: coda.ValueType.String},
autoMatchSpecifiedByUser: {type: coda.ValueType.String},
emailSubject: {type: coda.ValueType.String},
emailBlurb: {type: coda.ValueType.String},
signingLocation: {type: coda.ValueType.String},
authoritativeCopy: {type: coda.ValueType.String},
enforceSignerVisibility: {type: coda.ValueType.String},
enableWetSign: {type: coda.ValueType.String},
allowMarkup: {type: coda.ValueType.String},
allowReassign: {type: coda.ValueType.String},
disableResponsiveDocument: {type: coda.ValueType.String},
anySigner: {type: coda.ValueType.String},
envelopeLocation: {type: coda.ValueType.String},
},
displayProperty: "name",
idProperty: "templateId",
featuredProperties: ["templateId", "uri", "name", "shared", "passwordProtected", "description", "created", "lastModified", "lastUsed", "owner", "pageCount", "folderId", "folderName", "folderIds", "autoMatch", "autoMatchSpecifiedByUser", "emailSubject", "emailBlurb", "signingLocation", "authoritativeCopy", "enforceSignerVisibility", "enableWetSign", "allowMarkup", "allowReassign", "disableResponsiveDocument", "anySigner", "envelopeLocation"]
})
7
const schema_influencer_platform = coda.makeObjectSchema({. . .
const schema_influencer_platform = coda.makeObjectSchema({
properties: {
userName: {type: coda.ValueType.String},
userId: {type: coda.ValueType.String},
userType: {type: coda.ValueType.String},
isAdmin: {type: coda.ValueType.Boolean},
isAlternateAdmin: {type: coda.ValueType.Boolean},
userStatus: {type: coda.ValueType.String},
uri: {type: coda.ValueType.String},
email: {type: coda.ValueType.String},
title: {type: coda.ValueType.String},
createdDateTime: {type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime},
userAddedToAccountDateTime: {type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime},
firstName: {type: coda.ValueType.String},
middleName: {type: coda.ValueType.String},
lastName: {type: coda.ValueType.String},
suffixName: {type: coda.ValueType.String},
jobTitle: {type: coda.ValueType.String},
company: {type: coda.ValueType.String},
permissionProfileId: {type: coda.ValueType.String},
permissionProfileName: {type: coda.ValueType.String}
},
displayProperty: "userName",
idProperty: "userId",
featuredProperties: [
"userName",
"userId",
"userType",
"isAdmin",
"isAlternateAdmin",
"userStatus",
"uri",
"email",
"title",
"createdDateTime",
"userAddedToAccountDateTime",
"firstName",
"middleName",
"lastName",
"suffixName",
"jobTitle",
"company",
"permissionProfileId",
"permissionProfileName"
]
})
8
const schema_influencer_platform = coda.makeObjectSchema({. . .
const schema_influencer_platform = coda.makeObjectSchema({
properties: {
timestamp: {type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime},
numUgc: {type: coda.ValueType.Number},
numBlogFbShares: {type: coda.ValueType.Number},
numBlogFbLikes: {type: coda.ValueType.Number},
numBlogFbComments: {type: coda.ValueType.Number},
numBlogRetweets: {type: coda.ValueType.Number},
numBlogRepins: {type: coda.ValueType.Number},
numBlogGplusShares: {type: coda.ValueType.Number},
numBlogStumbleupons: {type: coda.ValueType.Number},
numBlogLinkedinShares: {type: coda.ValueType.Number},
numBlogImpressions: {type: coda.ValueType.Number},
numBlogClickthroughs: {type: coda.ValueType.Number},
numBlogUniqueImpressions: {type: coda.ValueType.Number},
numBlogUniqueClickthroughs: {type: coda.ValueType.Number},
conversionsValue: {type: coda.ValueType.Number},
convertedClicks: {type: coda.ValueType.Number},
uniqueConversions: {type: coda.ValueType.Number},
numSocialLikes: {type: coda.ValueType.Number},
numSocialShares: {type: coda.ValueType.Number},
numComments: {type: coda.ValueType.Number},
numVideoImpressions: {type: coda.ValueType.Number},
igReelImpressions: {type: coda.ValueType.Number},
inFeedVideoImpressions: {type: coda.ValueType.Number},
organicImpressions: {type: coda.ValueType.Number},
totalEngagement: {type: coda.ValueType.Number},
totalEngagementWithViews: {type: coda.ValueType.Number},
totalEngagementWithImpressions: {type: coda.ValueType.Number},
totalEngagementWithoutImpressions: {type: coda.ValueType.Number},
potentialReach: {type: coda.ValueType.Number},
totalPotentialReach: {type: coda.ValueType.Number},
uniqueReach: {type: coda.ValueType.String},
engImprRatio: {type: coda.ValueType.Number},
engWithViewsImprRatio: {type: coda.ValueType.Number},
engWithoutImpressionsImprRatio: {type: coda.ValueType.Number},
allTimeAvgEngRatio: {type: coda.ValueType.Number},
campaignPlatformEngImprRatio: {type: coda.ValueType.Number},
campaignPlatformEngWithViewsImprRatio: {type: coda.ValueType.Number},
improvementOverAllTimeAvgEngRatio: {type: coda.ValueType.Number},
improvementOverCampaignPlatformEngImprRatio: {type: coda.ValueType.Number},
improvementOverCampaignPlatformEngWithViewsImprRatio: {type: coda.ValueType.Number},
maleAudiencePct: {type: coda.ValueType.String},
femaleAudiencePct: {type: coda.ValueType.String},
maleAudienceReach: {type: coda.ValueType.Number},
femaleAudienceReach: {type: coda.ValueType.Number},
blogUmv: {type: coda.ValueType.Number},
totalClicks: {type: coda.ValueType.Number},
igStoryImpressionsRatio: {type: coda.ValueType.String},
igStoryLinkClicks: {type: coda.ValueType.String},
igStoryShares: {type: coda.ValueType.String},
igStoryReplies: {type: coda.ValueType.String},
igStoryProfileVisits: {type: coda.ValueType.String},
igStoryStickerTaps: {type: coda.ValueType.String},
igStoryImpressions: {type: coda.ValueType.String},
igStoryReach: {type: coda.ValueType.String},
igStoryFollows: {type: coda.ValueType.String},
igStoryBack: {type: coda.ValueType.String},
igStoryForward: {type: coda.ValueType.String},
igStoryNextStory: {type: coda.ValueType.String},
igStoryExited: {type: coda.ValueType.String},
igPostLikes: {type: coda.ValueType.Number},
igPostComments: {type: coda.ValueType.Number},
igPostShares: {type: coda.ValueType.Number},
igPostBookmarks: {type: coda.ValueType.Number},
igPostActionsTakenTotal: {type: coda.ValueType.Number},
igPostProfileVisits: {type: coda.ValueType.Number},
igPostReplies: {type: coda.ValueType.Number},
igPostWebsiteClicks: {type: coda.ValueType.Number},
igPostAccountsReached: {type: coda.ValueType.Number},
igPostNonFollowersReachedRatio: {type: coda.ValueType.Number},
igPostFollows: {type: coda.ValueType.Number},
igPostReach: {type: coda.ValueType.Number},
igPostImpressionsTotal: {type: coda.ValueType.Number},
igPostImpressionsFromHome: {type: coda.ValueType.Number},
igPostImpressionsFromHashtags: {type: coda.ValueType.Number},
igPostImpressionsFromProfile: {type: coda.ValueType.Number},
igPostImpressionsFromOther: {type: coda.ValueType.Number},
},
displayProperty: "timestamp",
});
9
const schema_influencer_platform = coda.makeObjectSchema({. . .
const schema_influencer_platform = coda.makeObjectSchema({
properties: {
numUgc: {type: coda.ValueType.Number},
numBlogFbShares: {type: coda.ValueType.Number},
numBlogFbLikes: {type: coda.ValueType.Number},
numBlogFbComments: {type: coda.ValueType.Number},
numBlogRetweets: {type: coda.ValueType.Number},
numBlogRepins: {type: coda.ValueType.Number},
numBlogGplusShares: {type: coda.ValueType.Number},
numBlogStumbleupons: {type: coda.ValueType.Number},
numBlogLinkedinShares: {type: coda.ValueType.Number},
numBlogImpressions: {type: coda.ValueType.Number},
numBlogClickthroughs: {type: coda.ValueType.Number},
numBlogUniqueImpressions: {type: coda.ValueType.Number},
numBlogUniqueClickthroughs: {type: coda.ValueType.Number},
conversionsValue: {type: coda.ValueType.Number},
convertedClicks: {type: coda.ValueType.Number},
uniqueConversions: {type: coda.ValueType.Number},
numSocialLikes: {type: coda.ValueType.Number},
numSocialShares: {type: coda.ValueType.Number},
numComments: {type: coda.ValueType.Number},
numVideoImpressions: {type: coda.ValueType.Number},
igReelImpressions: {type: coda.ValueType.Number},
inFeedVideoImpressions: {type: coda.ValueType.Number},
organicImpressions: {type: coda.ValueType.Number},
totalEngagement: {type: coda.ValueType.Number},
totalEngagementWithViews: {type: coda.ValueType.Number},
totalEngagementWithImpressions: {type: coda.ValueType.Number},
totalEngagementWithoutImpressions: {type: coda.ValueType.Number},
potentialReach: {type: coda.ValueType.Number},
totalPotentialReach: {type: coda.ValueType.Number},
uniqueReach: {type: coda.ValueType.String},
engImprRatio: {type: coda.ValueType.Number},
engWithViewsImprRatio: {type: coda.ValueType.Number},
engWithoutImpressionsImprRatio: {type: coda.ValueType.Number},
allTimeAvgEngRatio: {type: coda.ValueType.Number},
campaignPlatformEngImprRatio: {type: coda.ValueType.Number},
campaignPlatformEngWithViewsImprRatio: {type: coda.ValueType.Number},
improvementOverAllTimeAvgEngRatio: {type: coda.ValueType.Number},
improvementOverCampaignPlatformEngImprRatio: {type: coda.ValueType.Number},
improvementOverCampaignPlatformEngWithViewsImprRatio: {type: coda.ValueType.Number},
maleAudiencePct: {type: coda.ValueType.String},
femaleAudiencePct: {type: coda.ValueType.String},
maleAudienceReach: {type: coda.ValueType.Number},
femaleAudienceReach: {type: coda.ValueType.Number},
blogUmv: {type: coda.ValueType.Number},
totalClicks: {type: coda.ValueType.Number},
igStoryImpressionsRatio: {type: coda.ValueType.String},
igStoryLinkClicks: {type: coda.ValueType.String},
igStoryShares: {type: coda.ValueType.String},
igStoryReplies: {type: coda.ValueType.String},
igStoryProfileVisits: {type: coda.ValueType.String},
igStoryStickerTaps: {type: coda.ValueType.String},
igStoryImpressions: {type: coda.ValueType.String},
igStoryReach: {type: coda.ValueType.String},
igStoryFollows: {type: coda.ValueType.String},
igStoryBack: {type: coda.ValueType.String},
igStoryForward: {type: coda.ValueType.String},
igStoryNextStory: {type: coda.ValueType.String},
igStoryExited: {type: coda.ValueType.String},
igPostLikes: {type: coda.ValueType.Number},
igPostComments: {type: coda.ValueType.Number},
igPostShares: {type: coda.ValueType.Number},
igPostBookmarks: {type: coda.ValueType.Number},
igPostActionsTakenTotal: {type: coda.ValueType.Number},
igPostProfileVisits: {type: coda.ValueType.Number},
igPostReplies: {type: coda.ValueType.Number},
igPostWebsiteClicks: {type: coda.ValueType.Number},
igPostAccountsReached: {type: coda.ValueType.Number},
igPostNonFollowersReachedRatio: {type: coda.ValueType.Number},
igPostFollows: {type: coda.ValueType.Number},
igPostReach: {type: coda.ValueType.Number},
igPostImpressionsTotal: {type: coda.ValueType.Number},
igPostImpressionsFromHome: {type: coda.ValueType.Number},
igPostImpressionsFromHashtags: {type: coda.ValueType.Number},
igPostImpressionsFromProfile: {type: coda.ValueType.Number},
igPostImpressionsFromOther: {type: coda.ValueType.Number},
phyllo: {type: coda.ValueType.String},
},
displayProperty: “numUgc”
})
10
const schema_influencer_platform = coda.makeObjectSchema({. . .
const schema_influencer_platform = coda.makeObjectSchema({
properties: {
id: {type: coda.ValueType.Number},
influencer: {type: coda.ValueType.Number},
platformName: {type: coda.ValueType.String},
url: {type: coda.ValueType.String},
numFollowers: {type: coda.ValueType.Number},
avgNumcommentsOverall: {type: coda.ValueType.Number},
avgNumsharesOverall: {type: coda.ValueType.Number},
avgNumlikesOverall: {type: coda.ValueType.Number},
avgNumImpressions: {type: coda.ValueType.Number, codaType: coda.ValueHintType.DateTime},
sponsoredAvgNumImpressions: {type: coda.ValueType.Number, codaType: coda.ValueHintType.DateTime},
avgViewsRatio: {
type: coda.ValueType.Object,
properties: {
reels: {type: coda.ValueType.Number},
videos: {type: coda.ValueType.Number},
}
},
sponsoredAvgViewsRatio: {
type: coda.ValueType.Object,
properties: {
reels: {type: coda.ValueType.Number},
videos: {type: coda.ValueType.Number},
}
},
socialSignInUrl: {type: coda.ValueType.String},
erMetrics: {
type: coda.ValueType.Object,
properties: {
static: {type: coda.ValueType.Number},
reels: {type: coda.ValueType.Number},
}
},
sponsoredErMetrics: {
type: coda.ValueType.Object,
properties: {
static: {type: coda.ValueType.Number},
reels: {type: coda.ValueType.Number},
}
},
avgEngCounts: {
type: coda.ValueType.Object,
properties: {
shares: {type: coda.ValueType.Number},
comments: {type: coda.ValueType.Number},
likes: {type: coda.ValueType.Number},
}
},
isValid: {type: coda.ValueType.Boolean},
username: {type: coda.ValueType.String},
phylloAccount: {type: coda.ValueType.String},
},
displayProperty: "id”
})
11
const customfields_schema = coda.makeObjectSchema({properties: {. . .
const customfields_schema = coda.makeObjectSchema({properties: {
id: {type: coda.ValueType.String},
created: {type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime},
modified: {type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime},
hidden: {type: coda.ValueType.Boolean},
canApplyTo: {type: coda.ValueType.String},
clientAccess: {type: coda.ValueType.String},
clientLabel: {type: coda.ValueType.String},
choices: {type: coda.ValueType.String},
kind: {type: coda.ValueType.String},
name: {type: coda.ValueType.String},
token: {type: coda.ValueType.String}
}, displayProperty: "name", idProperty: "id", featuredProperties: ["id", "created", "modified", "hidden", "canApplyTo", "clientAccess", "clientLabel", "choices", "kind", "name", "token", "car", "kids", "is_nice", "age", "birthday"]})
12
const job_schema = coda.makeObjectSchema({. . .
const job_schema = coda.makeObjectSchema({
properties: {
id: {
type: coda.ValueType.String
},
created: {
type: coda.ValueType.String,
codaType: coda.ValueHintType.DateTime
},
modified: {
type: coda.ValueType.String,
codaType: coda.ValueHintType.DateTime
},
accountBalance: {
type: coda.ValueType.Number
},
bookingDate: {
type: coda.ValueType.String,
codaType: coda.ValueHintType.Date
},
brandId: {
type: coda.ValueType.String
},
closed: {
type: coda.ValueType.Boolean
},
closedReasonId: {
type: coda.ValueType.String
},
closedDate: {
type: coda.ValueType.String,
codaType: coda.ValueHintType.DateTime
},
closedReasonName: {
type: coda.ValueType.String
},
completedDate: {
type: coda.ValueType.String,
codaType: coda.ValueHintType.Date
},
contactFormId: {
type: coda.ValueType.String
},
creditBalance: {
type: coda.ValueType.Number
},
customNumber: {
type: coda.ValueType.String
},
eventDate: {
type: coda.ValueType.String,
codaType: coda.ValueHintType.Date
},
externalMappings: {
type: coda.ValueType.Array,
items: {
type: coda.ValueType.String
}
},
fulfillmentDate: {
type: coda.ValueType.String,
codaType: coda.ValueHintType.Date
},
guestCount: {
type: coda.ValueType.Number
},
inquiryDate: {
type: coda.ValueType.String,
codaType: coda.ValueHintType.Date
},
jobTypeId: {
type: coda.ValueType.String
},
jobTypeName: {
type: coda.ValueType.String
},
lastClientActivity: {
type: coda.ValueType.String,
codaType: coda.ValueHintType.DateTime
},
leadConfidence: {
type: coda.ValueType.String
},
leadDecisionExpectedByDate: {
type: coda.ValueType.String,
codaType: coda.ValueHintType.Date
},
leadMaxBudget: {
type: coda.ValueType.Number
},
leadNotes: {
type: coda.ValueType.String
},
leadRating: {
type: coda.ValueType.Number
},
leadSourceId: {
type: coda.ValueType.String
},
leadSourceName: {
type: coda.ValueType.String
},
leadStatusId: {
type: coda.ValueType.String
},
leadStatusName: {
type: coda.ValueType.String
},
leadStatusChangedAt: {
type: coda.ValueType.String,
codaType: coda.ValueHintType.DateTime
},
name: {
type: coda.ValueType.String
},
nextInteractionDate: {
type: coda.ValueType.String,
codaType: coda.ValueHintType.DateTime
},
nextInteractionItem: {
type: coda.ValueType.String
},
pinned: {
type: coda.ValueType.Boolean
},
primarySessionId: {
type: coda.ValueType.String
},
previousInteractionDate: {
type: coda.ValueType.String,
codaType: coda.ValueHintType.Date
},
previousInteractionItem: {
type: coda.ValueType.String
},
sample: {
type: coda.ValueType.Boolean
},
stage: {
type: coda.ValueType.String
},
staleDate: {
type: coda.ValueType.String,
codaType: coda.ValueHintType.Date
},
title: {
type: coda.ValueType.String
},
totalCost: {
type: coda.ValueType.Number
},
totalProfit: {
type: coda.ValueType.Number
},
totalRevenue: {
type: coda.ValueType.Number
},
webLead: {
type: coda.ValueType.Boolean
},
workflowId: {
type: coda.ValueType.String
},
workflowName: {
type: coda.ValueType.String
}
},
displayProperty: 'name',
idProperty: 'id',
featuredProperties: [
'id',
'created',
'modified',
'accountBalance',
'bookingDate',
'brandId',
'closed',
'closedReasonId',
'closedDate',
'closedReasonName',
'completedDate',
'contactFormId',
'creditBalance',
'customNumber',
'eventDate',
'externalMappings',
'fulfillmentDate',
'guestCount',
'inquiryDate',
'jobTypeId',
'jobTypeName',
'lastClientActivity',
'leadConfidence',
'leadDecisionExpectedByDate',
'leadMaxBudget',
'leadNotes',
'leadRating',
'leadSourceId',
'leadSourceName',
'leadStatusId',
'leadStatusName',
'leadStatusChangedAt',
'name',
'nextInteractionDate',
'nextInteractionItem',
'pinned',
'primarySessionId',
'previousInteractionDate',
'previousInteractionItem',
'sample',
'stage',
'staleDate',
'title',
'totalCost',
'totalProfit',
'totalRevenue',
'webLead',
'workflowId',
'workflowName',
'car',
'kids’
]
});
13
const userschema = coda.makeObjectSchema({. . .
const userschema = coda.makeObjectSchema({
properties: {
id: {type: coda.ValueType.String},
primaryEmail: {type: coda.ValueType.String},
password: {type: coda.ValueType.String},
hashFunction: {type: coda.ValueType.String},
isAdmin: {type: coda.ValueType.Boolean},
isDelegatedAdmin: {type: coda.ValueType.Boolean},
agreedToTerms: {type: coda.ValueType.Boolean},
suspended: {type: coda.ValueType.Boolean},
changePasswordAtNextLogin: {type: coda.ValueType.Boolean},
ipWhitelisted: {type: coda.ValueType.Boolean},
name: coda.makeObjectSchema({
properties: {
givenName: {type: coda.ValueType.String},
familyName: {type: coda.ValueType.String},
fullName: {type: coda.ValueType.String},
},
displayProperty: "fullName",
}),
kind: {type: coda.ValueType.String},
etag: {type: coda.ValueType.String},
emails: {type: coda.ValueType.Array, items: {type: coda.ValueType.String}},
externalIds: {type: coda.ValueType.Array, items: {type: coda.ValueType.String}},
relations: {type: coda.ValueType.Array, items: {type: coda.ValueType.String}},
aliases: {type: coda.ValueType.Array, items: {type: coda.ValueType.String}},
isMailboxSetup: {type: coda.ValueType.Boolean},
customerId: {type: coda.ValueType.String},
addresses: {type: coda.ValueType.Array, items: {type: coda.ValueType.String}},
organizations: {type: coda.ValueType.Array, items: {type: coda.ValueType.String}},
lastLoginTime: {type: coda.ValueType.String},
phones: {type: coda.ValueType.Array, items: {type: coda.ValueType.String}},
suspensionReason: {type: coda.ValueType.String},
thumbnailPhotoUrl: {type: coda.ValueType.String},
languages: {type: coda.ValueType.Array, items: {type: coda.ValueType.String}},
posixAccounts: {type: coda.ValueType.Array, items: {type: coda.ValueType.String}},
creationTime: {type: coda.ValueType.String},
nonEditableAliases: {type: coda.ValueType.Array, items: {type: coda.ValueType.String}},
sshPublicKeys: {type: coda.ValueType.Array, items: {type: coda.ValueType.String}},
notes: {type: coda.ValueType.Array, items: {type: coda.ValueType.String}},
websites: {type: coda.ValueType.Array, items: {type: coda.ValueType.String}},
locations: {type: coda.ValueType.Array, items: {type: coda.ValueType.String}},
includeInGlobalAddressList: {type: coda.ValueType.Boolean},
keywords: {type: coda.ValueType.Array, items: {type: coda.ValueType.String}},
deletionTime: {type: coda.ValueType.String},
gender: {type: coda.ValueType.String},
thumbnailPhotoEtag: {type: coda.ValueType.String},
ims: {type: coda.ValueType.Array, items: {type: coda.ValueType.String}},
customSchemas: {type: coda.ValueType.Array, items: {type: coda.ValueType.String}},
isEnrolledIn2Sv: {type: coda.ValueType.Boolean},
isEnforcedIn2Sv: {type: coda.ValueType.Boolean},
archived: {type: coda.ValueType.Boolean},
orgUnitPath: {type: coda.ValueType.String},
recoveryEmail: {type: coda.ValueType.String},
recoveryPhone: {type: coda.ValueType.String},
},
displayProperty: "primaryEmail",
idProperty: "id",
featuredProperties: [
"id",
"primaryEmail",
"password",
"hashFunction",
"isAdmin",
"isDelegatedAdmin",
"agreedToTerms",
"suspended",
"changePasswordAtNextLogin",
"ipWhitelisted",
"name",
"kind",
"etag",
"emails",
"externalIds",
"relations",
"aliases",
"isMailboxSetup",
"customerId",
"addresses",
"organizations",
"lastLoginTime",
"phones",
"suspensionReason",
"thumbnailPhotoUrl",
"languages",
"posixAccounts",
"creationTime",
"nonEditableAliases",
"sshPublicKeys",
"notes",
"websites",
"locations",
"includeInGlobalAddressList",
"keywords",
"deletionTime",
"gender",
"thumbnailPhotoEtag",
"ims",
"customSchemas",
"isEnrolledIn2Sv",
"isEnforcedIn2Sv",
"archived",
"orgUnitPath",
"recoveryEmail",
"recoveryPhone",
],
});
14
const detail_doc_schema = coda.makeObjectSchema({. . .
const detail_doc_schema = coda.makeObjectSchema({
properties: {
id: {type: coda.ValueType.String},
name: {type: coda.ValueType.String},
autonumbering_sequence_name_prefix: {type: coda.ValueType.String},
date_created: {type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime},
date_modified: {type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime},
date_completed: {type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime},
content_date_modified: {type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime},
created_by: coda.makeObjectSchema({
properties: {
id: {type: coda.ValueType.String},
membership_id: {type: coda.ValueType.String},
email: {type: coda.ValueType.String},
first_name: {type: coda.ValueType.String},
last_name: {type: coda.ValueType.String},
avatar: {type: coda.ValueType.String},
},
displayProperty: "email",
}),
template: coda.makeObjectSchema({
properties: {
id: {type: coda.ValueType.String},
name: {type: coda.ValueType.String},
},
displayProperty: "name",
}),
expiration_date: {type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime},
metadata: coda.makeObjectSchema({
properties: {
document__created_via_public_api: {type: coda.ValueType.String},
my_favorite_pet: {type: coda.ValueType.String},
opp_id: {type: coda.ValueType.String},
},
displayProperty: "document__created_via_public_api",
}),
tokens: coda.makeObjectSchema({
properties: {
name: {type: coda.ValueType.String},
value: {type: coda.ValueType.String},
},
displayProperty: "name",
}),
},
displayProperty: "name",
idProperty: "id",
featuredProperties: ["id", "name", "autonumbering_sequence_name_prefix", "date_created", "date_modified", "date_completed", "content_date_modified", "created_by", "template", "expiration_date", "metadata", "tokens"],
});
15
const document_schema = coda.makeObjectSchema({. . .
const document_schema = coda.makeObjectSchema({
properties: {
id: {type: coda.ValueType.String},
name: {type: coda.ValueType.String},
status: {type: coda.ValueType.String},
date_created: {type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime},
date_modified: {type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime},
date_completed: {type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime},
expiration_date: {type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime},
version: {type: coda.ValueType.String},
displayProperty: "name",
idProperty: "id",
featuredProperties: ["id","name","status","date_created","date_modified","date_completed","expiration_date","version"],
},
});
16
const webhook_schema = coda.makeObjectSchema({. . .
const webhook_schema = coda.makeObjectSchema({
properties: {
uuid: {type: coda.ValueType.String},
name: {type: coda.ValueType.String},
url: {type: coda.ValueType.String},
status: {type: coda.ValueType.String},
active: {type: coda.ValueType.Boolean},
payload: {type: coda.ValueType.Array, items: {}},
triggers: {type: coda.ValueType.Array, items: {type: coda.ValueType.String}},
shared_key: {type: coda.ValueType.String},
workspace_id: {type: coda.ValueType.String},
car: coda.makeObjectSchema({
properties: {
brand: {type: coda.ValueType.String},
model: {type: coda.ValueType.String}
},
displayProperty: "model”
})
},
displayProperty: "name",
idProperty: "uuid",
featuredProperties: ["uuid", "name", "url", "status", "active", "payload", "triggers", "shared_key", "workspace_id", "car"]
})
17
const groups = coda.makeObjectSchema({. . .
const groups = coda.makeObjectSchema({
properties: {
object: {type: coda.ValueType.String},
id: {type: coda.ValueType.String},
userId: {type: coda.ValueType.String},
name: {type: coda.ValueType.String},
email: {type: coda.ValueType.String},
twoFactorEnabled: {type: coda.ValueType.Boolean},
status: {type: coda.ValueType.Number},
collections: {type: coda.ValueType.Array, items: {type: coda.ValueType.Any}},
type: {type: coda.ValueType.Number},
accessAll: {type: coda.ValueType.Boolean},
externalId: {type: coda.ValueType.Any},
resetPasswordEnrolled: {type: coda.ValueType.Boolean}
},
displayProperty: "name”
});
18
const groups_schema = coda.makeObjectSchema({. . .
const groups_schema = coda.makeObjectSchema({
properties: {
object: {type: coda.ValueType.String},
id: {type: coda.ValueType.String},
collections: {type: coda.ValueType.Array, items: {type: coda.ValueType.Object, properties: {}, displayProperty: ""}},
name: {type: coda.ValueType.String},
accessAll: {type: coda.ValueType.Boolean},
externalId: {type: coda.ValueType.String},
},
displayProperty: "name",
idProperty: "id",
featuredProperties: ["object", "id", "collections", "name", "accessAll", "externalId"],
});
19
const product_schema = coda.makeObjectSchema({. . .
const product_schema = coda.makeObjectSchema({
properties: {
photoSet: coda.makeObjectSchema({
properties: {
small: {type: coda.ValueType.String},
medium: {type: coda.ValueType.String},
large: {type: coda.ValueType.String},
blur: {type: coda.ValueType.String}
}
}),
title: {type: coda.ValueType.String},
email: {type: coda.ValueType.String},
hidden: {type: coda.ValueType.Boolean},
blog: {type: coda.ValueType.String},
company: {type: coda.ValueType.String},
lastname: {type: coda.ValueType.String},
firstname: {type: coda.ValueType.String},
id: {type: coda.ValueType.Number}
},
displayProperty: "title",
idProperty: "id",
featuredProperties: ["photoSet", "title", "email", "hidden", "blog", "company", "lastname", "firstname", "id"]
})
20
const product_schema = coda.makeObjectSchema({. . .
const product_schema = coda.makeObjectSchema({
properties: {
created_at: {type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime},
currency: {type: coda.ValueType.String},
currency_rate: {type: coda.ValueType.String},
customer_id: {type: coda.ValueType.Number},
discount_total: {type: coda.ValueType.Number},
discount_total_formatted: {type: coda.ValueType.String},
discount_total_usd: {type: coda.ValueType.Number},
first_order_item: coda.makeObjectSchema({
properties: {
created_at: {type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime},
id: {type: coda.ValueType.Number},
order_id: {type: coda.ValueType.Number},
price: {type: coda.ValueType.Number},
price_id: {type: coda.ValueType.Number},
product_id: {type: coda.ValueType.Number},
product_name: {type: coda.ValueType.String},
test_mode: {type: coda.ValueType.Boolean},
updated_at: {type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime},
variant_id: {type: coda.ValueType.Number},
variant_name: {type: coda.ValueType.String}
}
}),
identifier: {type: coda.ValueType.String},
order_number: {type: coda.ValueType.Number},
refunded: {type: coda.ValueType.Boolean},
refunded_at: {type: coda.ValueType.String},
status: {type: coda.ValueType.String},
status_formatted: {type: coda.ValueType.String},
store_id: {type: coda.ValueType.Number},
subtotal: {type: coda.ValueType.Number},
subtotal_formatted: {type: coda.ValueType.String},
subtotal_usd: {type: coda.ValueType.Number},
tax: {type: coda.ValueType.Number},
tax_formatted: {type: coda.ValueType.String},
tax_name: {type: coda.ValueType.String},
tax_rate: {type: coda.ValueType.String},
tax_usd: {type: coda.ValueType.Number},
test_mode: {type: coda.ValueType.Boolean},
total: {type: coda.ValueType.Number},
total_formatted: {type: coda.ValueType.String},
total_usd: {type: coda.ValueType.Number},
updated_at: {type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime},
urls: coda.makeObjectSchema({
properties: {
receipt: {type: coda.ValueType.String}
}
}),
user_email: {type: coda.ValueType.String},
user_name: {type: coda.ValueType.String}
},
displayProperty: "created_at”
});
21
const product_schema = coda.makeObjectSchema({. . .
const product_schema = coda.makeObjectSchema({
properties: {
color: {type: coda.ValueType.String},
type: {type: coda.ValueType.String},
id: {type: coda.ValueType.String},
accountId: {type: coda.ValueType.String},
name: {type: coda.ValueType.String},
isActive: {type: coda.ValueType.Boolean},
email: {type: coda.ValueType.String},
avatar: {type: coda.ValueType.String},
picture: {type: coda.ValueType.String}
},
displayProperty: "name”
})
22
const product_schema = coda.makeObjectSchema({. . .
const product_schema = coda.makeObjectSchema({
properties: {
store_id: {type: coda.ValueType.Number},
name: {type: coda.ValueType.String},
slug: {type: coda.ValueType.String},
description: {type: coda.ValueType.String},
status: {type: coda.ValueType.String},
status_formatted: {type: coda.ValueType.String},
thumb_url: {type: coda.ValueType.String},
large_thumb_url: {type: coda.ValueType.String},
price: {type: coda.ValueType.Number},
price_formatted: {type: coda.ValueType.String},
from_price: {type: coda.ValueType.Any},
to_price: {type: coda.ValueType.Any},
pay_what_you_want: {type: coda.ValueType.Boolean},
buy_now_url: {type: coda.ValueType.String},
created_at: {type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime},
updated_at: {type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime},
test_mode: {type: coda.ValueType.Boolean},
store: coda.makeObjectSchema({
properties: {links: {type: coda.ValueType.Object}}}),
variants: coda.makeObjectSchema({
properties: {links: {type: coda.ValueType.Object}}})
},
displayProperty: "name",
idProperty: "id",
featuredProperties: ["store_id", "name", "slug", "description", "status", "thumb_url", "price", "created_at", "updated_at"]
})
23
const cand_schema = coda.makeObjectSchema({. . .
const cand_schema = coda.makeObjectSchema({
properties: {
id: {type: coda.ValueType.String},
created_at: {type: coda.ValueType.Number},
created_by: {type: coda.ValueType.String},
first_name: {type: coda.ValueType.String},
last_name: {type: coda.ValueType.String},
nickname: {type: coda.ValueType.String},
weblink: {type: coda.ValueType.String},
emails: {
type: coda.ValueType.Array,
items: {
type: coda.ValueType.Object,
properties: {
email_address: {type: coda.ValueType.String},
is_primary: {type: coda.ValueType.Boolean},
},
},
},
phone_number: {type: coda.ValueType.String},
location: {type: coda.ValueType.String},
linked_in_handle: {type: coda.ValueType.String},
profiles: {
type: coda.ValueType.Array,
items: {
type: coda.ValueType.Object,
properties: {
network: {type: coda.ValueType.String},
url: {type: coda.ValueType.String},
username: {type: coda.ValueType.String},
},
},
},
company: {type: coda.ValueType.String},
title: {type: coda.ValueType.String},
school: {type: coda.ValueType.String},
education_info: {
type: coda.ValueType.Array,
items: {
type: coda.ValueType.Object,
properties: {
school: {type: coda.ValueType.String},
start_date: {
type: coda.ValueType.String,
codaType: coda.ValueHintType.DateTime,
},
end_date: {
type: coda.ValueType.String,
codaType: coda.ValueHintType.DateTime,
},
field_of_study: {type: coda.ValueType.String},
degree: {type: coda.ValueType.String},
},
},
},
work_info: {
type: coda.ValueType.Array,
items: {
type: coda.ValueType.Object,
properties: {
company: {type: coda.ValueType.String},
title: {type: coda.ValueType.String},
work_start_date: {
type: coda.ValueType.String,
codaType: coda.ValueHintType.DateTime,
},
work_end_date: {
type: coda.ValueType.String,
codaType: coda.ValueHintType.DateTime,
},
is_current: {type: coda.ValueType.Boolean},
},
},
},
custom_fields: {
type: coda.ValueType.Array,
items: {
type: coda.ValueType.Object,
properties: {
id: {type: coda.ValueType.String},
name: {type: coda.ValueType.String},
scope: {type: coda.ValueType.String},
project_id: {type: coda.ValueType.String},
value: null,
value_type: {type: coda.ValueType.String},
value_option_ids: {
type: coda.ValueType.Array,
items: {type: coda.ValueType.String},
},
custom_field_category: {type: coda.ValueType.String},
custom_field_value: null,
},
},
},
due_date: {
type: coda.ValueType.Object,
properties: {
date: {
type: coda.ValueType.String,
codaType: coda.ValueHintType.Date,
},
user_id: {type: coda.ValueType.String},
note: {type: coda.ValueType.String},
},
},
project_ids: {
type: coda.ValueType.Array,
items: {type: coda.ValueType.String},
},
sourced_from: {type: coda.ValueType.String},
},
displayProperty: "first_name",
idProperty: "id",
featuredProperties: [
"id",
"created_at",
"created_by",
"first_name",
"last_name",
"nickname",
"weblink",
"emails",
"phone_number",
"location",
"linked_in_handle",
"profiles",
"company",
"title",
"school",
"education_info",
"work_info",
"custom_fields",
"due_date",
"project_ids",
"sourced_from",
],
});
24
const space_group_schema = coda.makeObjectSchema({. . .
const space_group_schema = coda.makeObjectSchema({
properties: {
id: { type: coda.ValueType.Number },
name: { type: coda.ValueType.String },
is_hidden_from_non_members: { type: coda.ValueType.Boolean },
allow_members_to_create_spaces: { type: coda.ValueType.Boolean },
community_id: { type: coda.ValueType.Number },
space_order_array: {
type: coda.ValueType.Array,
items: { type: coda.ValueType.Number }
},
created_at: {
type: coda.ValueType.String,
codaType: coda.ValueHintType.DateTime
},
updated_at: {
type: coda.ValueType.String,
codaType: coda.ValueHintType.DateTime
},
automatically_add_members_to_new_spaces: { type: coda.ValueType.Boolean },
add_members_to_space_group_on_space_join: { type: coda.ValueType.Boolean },
slug: { type: coda.ValueType.String },
hide_non_member_spaces_from_sidebar: { type: coda.ValueType.Boolean },
space_group_members_count: { type: coda.ValueType.Number },
active_space_group_members_count: { type: coda.ValueType.Number },
hide_members_count: { type: coda.ValueType.Null },
},
displayProperty: "name",
idProperty: "id",
featuredProperties: [
“id",
"name",
"is_hidden_from_non_members",
“allow_members_to_create_spaces",
"community_id",
“space_order_array",
“created_at",
"updated_at",
“automatically_add_members_to_new_spaces",
"add_members_to_space_group_on_space_join",
“slug",
"hide_non_member_spaces_from_sidebar",
"space_group_members_count",
"active_space_group_members_count",
“hide_members_count”
]
})
25
const event_schema = coda.makeObjectSchema({. . .
const event_schema = coda.makeObjectSchema({
properties: {
id: {type: coda.ValueType.Number},
name: {type: coda.ValueType.String},
slug: {type: coda.ValueType.String},
space_group_id: {type: coda.ValueType.Number},
space_group_name: {type: coda.ValueType.String},
url: {type: coda.ValueType.String},
community_id: {type: coda.ValueType.Number},
is_private: {type: coda.ValueType.Boolean},
hide_post_settings: {type: coda.ValueType.Boolean},
display_view: {type: coda.ValueType.String},
post_ids: {type: coda.ValueType.Array, items: {type: coda.ValueType.Number}},
is_post_disabled: {type: coda.ValueType.Boolean},
space_type: {type: coda.ValueType.String},
hide_topic_settings: {type: coda.ValueType.Boolean},
is_topic_disabled: {type: coda.ValueType.Boolean},
topic_ids: {type: coda.ValueType.Array, items: {type: coda.ValueType.Number}},
emoji: {type: coda.ValueType.String},
custom_emoji_url: {type: coda.ValueType.String},
custom_emoji_dark_url: {type: coda.ValueType.String},
},
displayProperty: "name",
idProperty: "id",
featuredProperties: [
"id",
"name",
"slug",
"space_group_id",
"space_group_name",
"url",
"community_id",
"is_private",
"hide_post_settings",
"display_view",
"post_ids",
"is_post_disabled",
"space_type",
"hide_topic_settings",
"is_topic_disabled",
"topic_ids",
"emoji",
"custom_emoji_url",
"custom_emoji_dark_url",
],
});
26
const event_schema = coda.makeObjectSchema({. . .
const event_schema = coda.makeObjectSchema({
properties: {
id: {type: coda.ValueType.Number},
space_id: {type: coda.ValueType.Number},
name: {type: coda.ValueType.String},
created_at: {type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime},
updated_at: {type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime},
},
displayProperty: "name",
idProperty: "id",
featuredProperties: ["id", "space_id", "name", "created_at", "updated_at"],
});
27
const event_schema = coda.makeObjectSchema({. . .
const event_schema = coda.makeObjectSchema({
properties: {
id: {type: coda.ValueType.Number},
name: {type: coda.ValueType.String},
emoji: {type: coda.ValueType.String},
color: {type: coda.ValueType.String},
community_id: {type: coda.ValueType.Number},
is_public: {type: coda.ValueType.Boolean},
display_locations: coda.makeObjectSchema({
properties: {
post_bio: {type: coda.ValueType.Boolean},
member_cards: {type: coda.ValueType.Boolean},
profile_page: {type: coda.ValueType.Boolean},
member_directory: {type: coda.ValueType.Boolean}
}
}),
display_format: {type: coda.ValueType.String},
created_at: {type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime},
updated_at: {type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime},
tagged_members_count: {type: coda.ValueType.Number},
custom_emoji_id: {type: coda.ValueType.String, optional: true}
},
displayProperty: "name",
idProperty: "id",
featuredProperties: ["id", "name", "emoji", "color", "community_id", "is_public", "display_locations", "display_format", "created_at", "updated_at", "tagged_members_count", "custom_emoji_id"]
})
28
Here is an example object schema for your Coda pack:. . .
Here is an example object schema for your Coda pack:
29
const event_schema = coda.makeObjectSchema({properties: {. . .
const event_schema = coda.makeObjectSchema({properties: {
id:{type:coda.ValueType.Number},
name:{type:coda.ValueType.String},
slug:{type:coda.ValueType.String},
body:{type:coda.ValueType.Object, codaType: coda.ValueHintType.Object, properties:{
id:{type:coda.ValueType.Number},
name:{type:coda.ValueType.String},
body:{type:coda.ValueType.String},
record_type:{type:coda.ValueType.String},
record_id:{type:coda.ValueType.Number},
created_at:{type:coda.ValueType.String, codaType: coda.ValueHintType.DateTime},
updated_at:{type:coda.ValueType.String, codaType: coda.ValueHintType.DateTime}
}, displayProperty: "name"},
space_id:{type:coda.ValueType.Number},
user_id:{type:coda.ValueType.Number},
community_member_id:{type:coda.ValueType.Number},
created_at:{type:coda.ValueType.String, codaType: coda.ValueHintType.DateTime},
hide_meta_info:{type:coda.ValueType.Boolean},
starts_at:{type:coda.ValueType.String, codaType: coda.ValueHintType.DateTime},
duration_in_seconds:{type:coda.ValueType.Number},
rsvp_disabled:{type:coda.ValueType.Boolean},
hide_attendees:{type:coda.ValueType.Boolean},
virtual_location_url:{type:coda.ValueType.String},
hide_location_from_non_attendees:{type:coda.ValueType.Boolean},
send_email_reminder:{type:coda.ValueType.Boolean},
send_in_app_notification_reminder:{type:coda.ValueType.Boolean},
enable_custom_thank_you_message:{type:coda.ValueType.Boolean},
send_email_confirmation:{type:coda.ValueType.Boolean},
send_in_app_notification_confirmation:{type:coda.ValueType.Boolean},
confirmation_message_title:{type:coda.ValueType.String},
confirmation_message_button_title:{type:coda.ValueType.String},
confirmation_message_button_link:{type:coda.ValueType.String},
ends_at:{type:coda.ValueType.String, codaType: coda.ValueHintType.DateTime},
confirmation_message_description:{type:coda.ValueType.String},
location_type:{type:coda.ValueType.String},
in_person_location:{type:coda.ValueType.String},
host:{type:coda.ValueType.String},
updated_at:{type:coda.ValueType.String, codaType: coda.ValueHintType.DateTime},
url:{type:coda.ValueType.String},
space_name:{type:coda.ValueType.String},
space_slug:{type:coda.ValueType.String},
member_email:{type:coda.ValueType.String},
member_name:{type:coda.ValueType.String},
comments_count:{type:coda.ValueType.Number},
likes_count:{type:coda.ValueType.Number},
community_id:{type:coda.ValueType.Number},
member_avatar_url:{type:coda.ValueType.String},
zapier_display_title:{type:coda.ValueType.String}
}, displayProperty: "name", idProperty: "id", featuredProperties: ["id","name","slug","body","space_id","user_id","community_member_id","created_at","hide_meta_info","starts_at","duration_in_seconds","rsvp_disabled","hide_attendees","virtual_location_url","hide_location_from_non_attendees","send_email_reminder","send_in_app_notification_reminder","enable_custom_thank_you_message","send_email_confirmation","send_in_app_notification_confirmation","confirmation_message_title","confirmation_message_button_title","confirmation_message_button_link","ends_at","confirmation_message_description","location_type","in_person_location","host","updated_at","url","space_name","space_slug","member_email","member_name","comments_count","likes_count","community_id","member_avatar_url","zapier_display_title"]})
30
const connection_schema = coda.makeObjectSchema({. . .
const connection_schema = coda.makeObjectSchema({
properties: {
id: {type: coda.ValueType.String},
team_id: {type: coda.ValueType.String},
archived_at: {type: coda.ValueType.String},
updated_at: {type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime},
created_at: {type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime},
paused_at: {type: coda.ValueType.String},
name: {type: coda.ValueType.String},
rules: {
type: coda.ValueType.Array,
items: {
type: coda.makeObjectSchema({
properties: {
type: {type: coda.ValueType.String},
count: {type: coda.ValueType.Number},
interval: {type: coda.ValueType.Number},
strategy: {type: coda.ValueType.String}
}
})
}
},
description: {type: coda.ValueType.String},
destination: coda.makeObjectSchema({
properties: {
id: {type: coda.ValueType.String},
team_id: {type: coda.ValueType.String},
url: {type: coda.ValueType.String},
archived_at: {type: coda.ValueType.String},
updated_at: {type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime},
created_at: {type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime},
rate_limit: {type: coda.ValueType.String},
rate_limit_period: {type: coda.ValueType.String},
cli_path: {type: coda.ValueType.String},
path_forwarding_disabled: {type: coda.ValueType.Boolean},
name: {type: coda.ValueType.String},
http_method: {type: coda.ValueType.String},
auth_method: coda.makeObjectSchema({
properties: {
type: {type: coda.ValueType.String},
config: coda.makeObjectSchema({
properties: {
token: {type: coda.ValueType.String}
}
})
}
}),
description: {type: coda.ValueType.String}
},
displayProperty: "name”
}),
source: coda.makeObjectSchema({
properties: {
id: {type: coda.ValueType.String},
team_id: {type: coda.ValueType.String},
archived_at: {type: coda.ValueType.String},
updated_at: {type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime},
created_at: {type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime},
name: {type: coda.ValueType.String},
allowed_http_methods: {
type: coda.ValueType.Array,
items: {type: coda.ValueType.String}
},
custom_response: {type: coda.ValueType.String},
description: {type: coda.ValueType.String},
url: {type: coda.ValueType.String},
verification: {type: coda.ValueType.String}
},
displayProperty: "name”
}),
full_name: {type: coda.ValueType.String}
},
displayProperty: "name",
idProperty: "id",
featuredProperties: ["id","team_id","archived_at","updated_at","created_at","paused_at","name","rules","description","destination","source","full_name"]
})
31
const customer_schema = coda.makeObjectSchema({. . .
const customer_schema = coda.makeObjectSchema({
properties: {
name: {type: coda.ValueType.String},
age: {type: coda.ValueType.Number},
is_nice: {type: coda.ValueType.Boolean},
birthday: {type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime},
kids: {type: coda.ValueType.Array, items: {type: coda.ValueType.String}},
car: coda.MakeObjectSchema({
properties: {
brand: {type: coda.ValueType.String},
model: {type: coda.ValueType.String}
},
displayProperty: “model”
})
},
displayProperty: “name”
})
32
const customer_schema = coda.makeObjectSchema({. . .
const customer_schema = coda.makeObjectSchema({
properties: {
name: {type: coda.ValueType.String},
age: {type: coda.ValueType.Number},
is_nice: {type: coda.ValueType.Boolean},
birthday: {type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime},
kids: {type: coda.ValueType.Array, items: {type: coda.ValueType.String}},
car: coda.makeObjectSchema({
properties: {
brand: {type: coda.ValueType.String},
model: {type: coda.ValueType.String},
},
displayProperty: "model”
})
},
displayProperty: "name",
idProperty: "birthday",
featuredProperties: ["name", "age", "is_nice", "birthday", "kids", "car"]
})
33
const product_schema = coda.makeObjectSchema({. . .
const product_schema = coda.makeObjectSchema({
properties: {
product_id: {type: coda.ValueType.String},
name: {type: coda.ValueType.String},
label: {type: coda.ValueType.String},
url: {type: coda.ValueType.String},
embed_type: {type: coda.ValueType.String},
status: {type: coda.ValueType.String},
statusString: {type: coda.ValueType.String},
type: {type: coda.ValueType.String},
typeString: {type: coda.ValueType.String}
},
displayProperty: "name",
idProperty: "product_id",
featuredProperties: ["product_id", "name", "label", "url", "embed_type", "status", "statusString", "type", "typeString"]
})
34
const transaction_schema = coda.makeObjectSchema({. . .
const transaction_schema = coda.makeObjectSchema({
properties: {
event_id: { type: coda.ValueType.String },
base_product: { type: coda.ValueType.String },
date: { type: coda.ValueType.String, codaType: coda.ValueHintType.Date },
time: { type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime },
timestamp: { type: coda.ValueType.Number },
transaction_type: { type: coda.ValueType.String },
transaction_info: { type: coda.ValueType.String },
item_type: { type: coda.ValueType.String },
item_id: { type: coda.ValueType.Number },
item_name: { type: coda.ValueType.String },
item_pricing_option_name: { type: coda.ValueType.String },
item_pricing_option_id: { type: coda.ValueType.String },
subscription_id: { type: coda.ValueType.String },
internal_subscription_id: { type: coda.ValueType.String },
transaction_id: { type: coda.ValueType.String },
amount: { type: coda.ValueType.Number },
order_id: { type: coda.ValueType.String },
invoice_id: { type: coda.ValueType.String },
currency: { type: coda.ValueType.String },
processor: { type: coda.ValueType.String },
customer: coda.makeObjectSchema({
properties: {
name: { type: coda.ValueType.String },
email: { type: coda.ValueType.String },
},
displayProperty: "name",
}),
coupon: { type: coda.ValueType.String },
campaign_id: { type: coda.ValueType.String },
quantity: { type: coda.ValueType.Number },
reference: { type: coda.ValueType.String },
},
displayProperty: "event_id",
idProperty: "event_id",
featuredProperties: [
"event_id",
"base_product",
"date",
"time",
"timestamp",
"transaction_type",
"transaction_info",
"item_type",
"item_id",
"item_name",
"item_pricing_option_name",
"item_pricing_option_id",
"subscription_id",
"internal_subscription_id",
"transaction_id",
"amount",
"order_id",
"invoice_id",
"currency",
"processor",
"customer",
"coupon",
"campaign_id",
"quantity",
"reference",
],
});
35
const employee_schema = coda.makeObjectSchema({. . .
const employee_schema = coda.makeObjectSchema({
properties: {
id: {type: coda.ValueType.String},
employeeId: {type: coda.ValueType.String},
name: {type: coda.ValueType.String},
status: coda.makeObjectSchema({
properties: {
lastChanged: {type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime},
lastChangedByUserId: {type: coda.ValueType.String},
status: {type: coda.ValueType.String}
},
displayProperty: "status”
}),
start: {type: coda.ValueType.String, codaType: coda.ValueHintType.Date},
end: {type: coda.ValueType.String, codaType: coda.ValueHintType.Date},
created: {type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime},
type: coda.makeObjectSchema({
properties: {
id: {type: coda.ValueType.String},
name: {type: coda.ValueType.String},
icon: {type: coda.ValueType.String}
},
displayProperty: "name”
}),
amount: coda.makeObjectSchema({
properties: {
unit: {type: coda.ValueType.String},
amount: {type: coda.ValueType.String}
}
}),
actions: coda.makeObjectSchema({
properties: {
view: {type: coda.ValueType.Boolean},
edit: {type: coda.ValueType.Boolean},
cancel: {type: coda.ValueType.Boolean},
approve: {type: coda.ValueType.Boolean},
deny: {type: coda.ValueType.Boolean},
bypass: {type: coda.ValueType.Boolean}
}
}),
dates: coda.makeObjectSchema({
properties: {
"2001-01-01": {type: coda.ValueType.String},
"2001-01-02": {type: coda.ValueType.String},
"2001-01-03": {type: coda.ValueType.String},
"2001-01-04": {type: coda.ValueType.String},
"2001-01-05": {type: coda.ValueType.String},
"2001-01-06": {type: coda.ValueType.String}
}
}),
notes: coda.makeObjectSchema({
properties: {
employee: {type: coda.ValueType.String},
manager: {type: coda.ValueType.String}
},
displayProperty: "employee”
})
},
displayProperty: "name",
idProperty: "id",
featuredProperties: ["id", "employeeId", "name", "status", "start", "end", "created", "type", "amount", "actions", "dates", "notes"]
})
36
const employee_schema = coda.makeObjectSchema({. . .
const employee_schema = coda.makeObjectSchema({
properties: {
id: {type: coda.ValueType.String},
displayName: {type: coda.ValueType.String},
firstName: {type: coda.ValueType.String},
lastName: {type: coda.ValueType.String},
preferredName: {type: coda.ValueType.String, codaType: coda.ValueHintType.SingleLineText},
jobTitle: {type: coda.ValueType.String},
workPhone: {type: coda.ValueType.String},
workEmail: {type: coda.ValueType.String},
department: {type: coda.ValueType.String},
location: {type: coda.ValueType.String},
division: {type: coda.ValueType.String},
linkedIn: {type: coda.ValueType.String},
pronouns: {type: coda.ValueType.String, codaType: coda.ValueHintType.SingleLineText},
workPhoneExtension: {type: coda.ValueType.String, codaType: coda.ValueHintType.SingleLineText},
supervisor: {type: coda.ValueType.String},
photoUploaded: {type: coda.ValueType.Boolean},
photoUrl: {type: coda.ValueType.String},
canUploadPhoto: {type: coda.ValueType.Number}
},
displayProperty: "displayName",
idProperty: "id",
featuredProperties: ["id", "displayName", "firstName", "lastName", "preferredName", "jobTitle", "workPhone", "workEmail", "department", "location", "division", "linkedIn", "pronouns", "workPhoneExtension", "supervisor", "photoUploaded", "photoUrl", "canUploadPhoto"]
})
37
const task_schema = coda.makeObjectSchema({. . .
const task_schema = coda.makeObjectSchema({
properties: {
task_id: { type: coda.ValueType.String, fromKey: “id” },
required: { type: coda.ValueType.Boolean },
completed: { type: coda.ValueType.Boolean },
completion_action: { type: coda.ValueType.String },
completion_action_translated: { type: coda.ValueType.String },
completed_at: { type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime },
deadline: { type: coda.ValueType.String },
deadline_offset: { type: coda.ValueType.String },
deadline_offset_unit: { type: coda.ValueType.String },
deadline_offset_task_id: { type: coda.ValueType.String },
deadline_offset_task_action: { type: coda.ValueType.String },
description: { type: coda.ValueType.String },
instruction: { type: coda.ValueType.String },
parent_id: { type: coda.ValueType.String },
parent_title: { type: coda.ValueType.String },
parent_type: { type: coda.ValueType.String },
parent_type_name: { type: coda.ValueType.String },
parent_progress_stage: { type: coda.ValueType.Number },
parent_url: { type: coda.ValueType.String },
position: { type: coda.ValueType.Number },
rules: { type: coda.ValueType.Array, items: { type: coda.ValueType.Object } },
task_rules: { type: coda.ValueType.Array, items: { type: coda.ValueType.Object } },
state: { type: coda.ValueType.Number },
overdue: { type: coda.ValueType.Boolean },
updated_at: { type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime },
user_ids: { type: coda.ValueType.Array, items: { type: coda.ValueType.String } },
accessible_user_ids: { type: coda.ValueType.Array, items: { type: coda.ValueType.String } },
is_next_task: { type: coda.ValueType.Boolean },
type: { type: coda.ValueType.String },
available_actions: { type: coda.ValueType.Array, items: { type: coda.ValueType.String } },
workflow_stage_id: { type: coda.ValueType.String },
workflow_stage_display_name: { type: coda.ValueType.String },
workflow_stage_status: { type: coda.ValueType.String },
archived: { type: coda.ValueType.Boolean },
dependencies: { type: coda.ValueType.Array, items: { type: coda.ValueType.Object } },
is_dependent_task: { type: coda.ValueType.Boolean },
readiness: { type: coda.ValueType.String },
last_updated_by_id: { type: coda.ValueType.String },
newsroom_id: { type: coda.ValueType.String },
},
displayProperty: "id",
idProperty: "id",
featuredProperties: [
"id",
"required",
"completed",
"completion_action",
"completion_action_translated",
"completed_at",
"deadline",
"deadline_offset",
"deadline_offset_unit",
"deadline_offset_task_id",
"deadline_offset_task_action",
"description",
"instruction",
"parent_id",
"parent_title",
"parent_type",
"parent_type_name",
"parent_progress_stage",
"parent_url",
"position",
"rules",
"task_rules",
"state",
"owners",
"overdue",
"updated_at",
"user_ids",
"accessible_user_ids",
"is_next_task",
"type",
"available_actions",
"workflow_stage_id",
"workflow_stage_display_name",
"workflow_stage_status",
"archived",
"dependencies",
"is_dependent_task",
"readiness",
"last_updated_by_id",
"newsroom_id",
],
})
38
javascript
const cost_basis_schema = coda.makeObjectSchema({
properties: {
id: { type: coda.ValueType.String },
email: { type: coda.ValueType.String },
name: { type: coda.ValueType.String },
name_sort: { type: coda.ValueType.String },
avatar_feed_url: { type: coda.ValueType.String },
avatar_thumbnail_url: { type: coda.ValueType.String },
avatar_profile_large_url: { type: coda.ValueType.String },
avatar_profile_url: { type: coda.ValueType.String },
slug: { type: coda.ValueType.String },
created_at: { type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime },
updated_at: { type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime },
bio: { type: coda.ValueType.Null },
short_bio: { type: coda.ValueType.String },
visitor: { type: coda.ValueType.Boolean },
tz: { type: coda.ValueType.String },
follow_discussion_allowed: { type: coda.ValueType.Boolean },
superadmin: { type: coda.ValueType.Boolean },
tours_seen: { type: coda.ValueType.Array, items: { type: coda.ValueType.Any } },
phone: { type: coda.ValueType.Null },
removed: { type: coda.ValueType.Boolean },
role: { type: coda.ValueType.String },
group_ids: { type: coda.ValueType.Array, items: { type: coda.ValueType.String } }
},
displayProperty: "name"
});
. . .
javascript
const cost_basis_schema = coda.makeObjectSchema({
properties: {
id: { type: coda.ValueType.String },
email: { type: coda.ValueType.String },
name: { type: coda.ValueType.String },
name_sort: { type: coda.ValueType.String },
avatar_feed_url: { type: coda.ValueType.String },
avatar_thumbnail_url: { type: coda.ValueType.String },
avatar_profile_large_url: { type: coda.ValueType.String },
avatar_profile_url: { type: coda.ValueType.String },
slug: { type: coda.ValueType.String },
created_at: { type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime },
updated_at: { type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime },
bio: { type: coda.ValueType.Null },
short_bio: { type: coda.ValueType.String },
visitor: { type: coda.ValueType.Boolean },
tz: { type: coda.ValueType.String },
follow_discussion_allowed: { type: coda.ValueType.Boolean },
superadmin: { type: coda.ValueType.Boolean },
tours_seen: { type: coda.ValueType.Array, items: { type: coda.ValueType.Any } },
phone: { type: coda.ValueType.Null },
removed: { type: coda.ValueType.Boolean },
role: { type: coda.ValueType.String },
group_ids: { type: coda.ValueType.Array, items: { type: coda.ValueType.String } }
},
displayProperty: "name"
});
39
const cost_basis_schema = coda.makeObjectSchema({. . .
const cost_basis_schema = coda.makeObjectSchema({
properties: {
id: { type: coda.ValueType.String },
name: { type: coda.ValueType.String },
filters: {
type: coda.ValueType.Object,
properties: {
mainFilters: {
type: coda.ValueType.Array,
items: {
type: coda.ValueType.Object,
properties: {
label: { type: coda.ValueType.String },
value: { type: coda.ValueType.String },
showAdvanced: { type: coda.ValueType.Boolean }
}
}
},
moreFilters: {
type: coda.ValueType.Array,
items: {
type: coda.ValueType.Object
}
}
}
},
rules: { type: coda.ValueType.Object },
auto_add_setting: { type: coda.ValueType.String },
color: { type: coda.ValueType.Number },
description: { type: coda.ValueType.String },
permission_type: { type: coda.ValueType.String },
prompt_login_enabled: { type: coda.ValueType.Boolean },
last_viewed_at: {
type: coda.ValueType.String,
codaType: coda.ValueHintType.DateTime
},
umbrella_id: { type: coda.ValueType.String },
created_at: {
type: coda.ValueType.String,
codaType: coda.ValueHintType.DateTime
},
updated_at: {
type: coda.ValueType.String,
codaType: coda.ValueHintType.DateTime
},
auto_expand_tags: { type: coda.ValueType.Boolean },
collection_view_custom_field: { type: coda.ValueType.Object }
},
displayProperty: "name",
idProperty: "id",
featuredProperties: [
"id",
"name",
"filters",
"rules",
"auto_add_setting",
"color",
"description",
"permission_type",
"prompt_login_enabled",
"last_viewed_at",
"umbrella_id",
"created_at",
"updated_at",
"auto_expand_tags",
"collection_view_custom_field”
]
})
40
const cost_basis_schema = coda.makeObjectSchema({. . .
const cost_basis_schema = coda.makeObjectSchema({
properties: {
id: { type: coda.ValueType.String },
slug: { type: coda.ValueType.String },
title: { type: coda.ValueType.String },
creator_id: { type: coda.ValueType.String },
assignee_id: { type: coda.ValueType.String },
campaign_ids: {
type: coda.ValueType.Array,
items: { type: coda.ValueType.String }
},
preferred_title: { type: coda.ValueType.String },
next_task: { type: coda.ValueType.String },
state: { type: coda.ValueType.String },
archived: { type: coda.ValueType.Boolean },
updated_at: { type: coda.ValueType.String },
factory_url: { type: coda.ValueType.String },
content_type: coda.makeObjectSchema({
properties: {
background_color: { type: coda.ValueType.String },
body_type: { type: coda.ValueType.String },
display_name: { type: coda.ValueType.String },
field_name: { type: coda.ValueType.String },
icon: { type: coda.ValueType.String },
icon_css_class: { type: coda.ValueType.String },
id: { type: coda.ValueType.String },
newsroom_id: { type: coda.ValueType.String },
updated_at: { type: coda.ValueType.String },
display_name_sort: { type: coda.ValueType.String }
},
displayProperty: "display_name",
idProperty: "id",
featuredProperties: [
"background_color",
"body_type",
"display_name",
"field_name",
"icon",
"icon_css_class",
"id",
"newsroom_id",
"updated_at",
"display_name_sort”
]
}),
progress_stage: { type: coda.ValueType.String },
published_date: { type: coda.ValueType.String },
synced_to_gallery_date: { type: coda.ValueType.String },
content_number: { type: coda.ValueType.Number }
},
displayProperty: "title",
idProperty: "id",
featuredProperties: [
"id",
"slug",
"title",
"creator_id",
"assignee_id",
"campaign_ids",
"preferred_title",
"next_task",
"state",
"archived",
"updated_at",
"factory_url",
"content_type",
"progress_stage",
"published_date",
"synced_to_gallery_date",
"content_number”
]
})
41
const cost_basis_schema = coda.makeObjectSchema({. . .
const cost_basis_schema = coda.makeObjectSchema({
properties: {
id: {type: coda.ValueType.String},
displayName: {type: coda.ValueType.String},
parentFolderId: {type: coda.ValueType.String},
childFolderCount: {type: coda.ValueType.Number},
unreadItemCount: {type: coda.ValueType.Number},
totalItemCount: {type: coda.ValueType.Number},
sizeInBytes: {type: coda.ValueType.Number},
isHidden: {type: coda.ValueType.Boolean}
},
displayProperty: "displayName",
idProperty: "id",
featuredProperties: ["id", "displayName", "parentFolderId", "childFolderCount", "unreadItemCount", "totalItemCount", "sizeInBytes", "isHidden"]
})
42
const cost_basis_schema = coda.makeObjectSchema({. . .
const cost_basis_schema = coda.makeObjectSchema({
properties: {
id: {type: coda.ValueType.String},
cusip: {type: coda.ValueType.String},
symbol: {type: coda.ValueType.String},
description: {type: coda.ValueType.String},
quantity: {type: coda.ValueType.Number},
market_value: {type: coda.ValueType.Number},
cost_basis_unadjusted: {type: coda.ValueType.Number},
cost_basis_adjusted: {type: coda.ValueType.Number},
unrealized_gain_loss: {type: coda.ValueType.Number},
as_of_date: {type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime},
open_date: {type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime},
car: coda.makeObjectSchema({
properties: {
brand: {type: coda.ValueType.String},
model: {type: coda.ValueType.String},
},
displayProperty: "model",
}),
},
displayProperty: "description",
idProperty: "id",
featuredProperties: [
"id",
"cusip",
"symbol",
"description",
"quantity",
"market_value",
"cost_basis_unadjusted",
"cost_basis_adjusted",
"unrealized_gain_loss",
"as_of_date",
"open_date",
],
});
43
const account_schema = coda.makeObjectSchema({. . .
const account_schema = coda.makeObjectSchema({
properties: {
id: { type: coda.ValueType.String },
rep_code: { type: coda.ValueType.String },
account_type: { type: coda.ValueType.String },
account_name: { type: coda.ValueType.String },
status: { type: coda.ValueType.String },
date_open: { type: coda.ValueType.String, codaType: coda.ValueHintType.Date },
date_closed: { type: coda.ValueType.String, codaType: coda.ValueHintType.Date },
as_of_date: { type: coda.ValueType.String, codaType: coda.ValueHintType.Date },
account_balance: { type: coda.ValueType.Number }
},
displayProperty: "account_name",
idProperty: "id",
featuredProperties: ["id", "rep_code", "account_type", "account_name", "status", "date_open", "date_closed", "as_of_date", "account_balance"]
})
44
const member_schema = coda.makeObjectSchema({. . .
const member_schema = coda.makeObjectSchema({
properties: {
type: {type: coda.ValueType.Number},
accessAll: {type: coda.ValueType.Boolean},
externalId: {type: coda.ValueType.String},
resetPasswordEnrolled: {type: coda.ValueType.Boolean},
object: {type: coda.ValueType.String},
id: {type: coda.ValueType.String},
userId: {type: coda.ValueType.String},
name: {type: coda.ValueType.String},
email: {type: coda.ValueType.String},
twoFactorEnabled: {type: coda.ValueType.Boolean},
status: {type: coda.ValueType.Number},
collections: {
type: coda.ValueType.Array,
items: coda.makeObjectSchema({
properties: {
id: {type: coda.ValueType.String},
readOnly: {type: coda.ValueType.Boolean}
}
})
}
},
displayProperty: "name",
idProperty: "id",
featuredProperties: ["type", "accessAll", "externalId", "resetPasswordEnrolled", "object", "id", "userId", "name", "email", "twoFactorEnabled", "status", "collections"]
})
45
const integration_schema = coda.makeObjectSchema({. . .
const integration_schema = coda.makeObjectSchema({
properties: {
id: { type: coda.ValueType.Number },
name: { type: coda.ValueType.String },
email: { type: coda.ValueType.String },
location: coda.makeObjectSchema({
properties: {
city: { type: coda.ValueType.String },
region: { type: coda.ValueType.String },
country: { type: coda.ValueType.String },
},
displayProperty: "city",
}),
platform: { type: coda.ValueType.String },
created_at: { type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime },
updated_at: { type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime },
events: { type: coda.ValueType.Object },
self: { type: coda.ValueType.Object },
watching: { type: coda.ValueType.Object },
watchlist: { type: coda.ValueType.Object },
latest_event: coda.makeObjectSchema({
properties: {
product: { type: coda.ValueType.Object },
customer: { type: coda.ValueType.Object },
_embedded: { type: coda.ValueType.Object },
topic: { type: coda.ValueType.String },
data: coda.makeObjectSchema({
properties: {
action: { type: coda.ValueType.String },
action_type: { type: coda.ValueType.String },
status: { type: coda.ValueType.String },
frequency: { type: coda.ValueType.String },
price: { type: coda.ValueType.Number },
platform: { type: coda.ValueType.String },
},
}),
created_at: { type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime },
},
displayProperty: "topic",
}),
thumbnail: { type: coda.ValueType.String },
plan: { type: coda.ValueType.String },
marketing_opt_in: { type: coda.ValueType.Boolean },
registered_to_site: { type: coda.ValueType.Boolean },
subscribed_to_site: { type: coda.ValueType.Boolean },
},
displayProperty: "name",
idProperty: "id",
featuredProperties: ["id", "name", "email", "location", "platform", "created_at", "updated_at", "events", "self", "watching", "watchlist", "latest_event", "thumbnail", "plan", "marketing_opt_in", "registered_to_site", "subscribed_to_site"],
});
46
const integration_schema = coda.makeObjectSchema({. . .
const integration_schema = coda.makeObjectSchema({
properties: {
id: {type: coda.ValueType.String},
type: {type: coda.ValueType.String},
attributes: coda.makeObjectSchema({
properties: {
endpoint: {type: coda.ValueType.String},
service_name: {type: coda.ValueType.String},
},
displayProperty: "service_name",
}),
},
displayProperty: "id",
idProperty: "id",
featuredProperties: ["id", "type", "attributes"],
})
47
const published_info = coda.makeObjectSchema({. . .
const published_info = coda.makeObjectSchema({
properties: {
description: {type: coda.ValueType.String},
browserLink: {type: coda.ValueType.String},
imageLink: {type: coda.ValueType.String},
discoverable: {type: coda.ValueType.Boolean},
earnCredit: {type: coda.ValueType.Boolean},
mode: {type: coda.ValueType.String},
categories: {type: coda.ValueType.Array, items: {type: coda.ValueType.String}}
},
displayProperty: "description”
})
48
const published_info = coda.makeObjectSchema({. . .
const published_info = coda.makeObjectSchema({
properties: {
description: {type: coda.ValueType.String},
browserLink: {type: coda.ValueType.String},
imageLink: {type: coda.ValueType.String},
discoverable: {type: coda.ValueType.Boolean},
earnCredit: {type: coda.ValueType.Boolean},
mode: {type: coda.ValueType.String},
categories: {
type: coda.ValueType.Array,
items: {type: coda.ValueType.String}
}
},
displayProperty: "description”
})
49
const published_info = coda.makeObjectSchema({. . .
const published_info = coda.makeObjectSchema({
properties: {
description: {type: coda.ValueType.String},
browserLink: {type: coda.ValueType.String},
imageLink: {type: coda.ValueType.String},
discoverable: {type: coda.ValueType.Boolean},
earnCredit: {type: coda.ValueType.Boolean},
mode: {type: coda.ValueType.String},
categories: {
type: coda.ValueType.Array,
items: {type: coda.ValueType.String}
}
},
displayProperty: "description”
})
50
const planet_schema = coda.makeObjectSchema({. . .
const planet_schema = coda.makeObjectSchema({
properties: {
campaign: {type: coda.ValueType.String},
coupon_code: {type: coda.ValueType.String},
created_at: {type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime},
email: {type: coda.ValueType.String},
first_name: {type: coda.ValueType.String},
id: {type: coda.ValueType.Number},
last_name: {type: coda.ValueType.String},
last_payment_date: {type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime},
location: coda.makeObjectSchema({
properties: {
city: {type: coda.ValueType.String},
country: {type: coda.ValueType.String},
region: {type: coda.ValueType.String}
}
}),
marketing_opt_in: {type: coda.ValueType.Boolean},
name: {type: coda.ValueType.String},
next_payment_date: {type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime},
pause_end_date: {type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime},
plan: {type: coda.ValueType.String},
platform: {type: coda.ValueType.String},
promotion_code: {type: coda.ValueType.String},
referrer: {type: coda.ValueType.String},
registered_to_site: {type: coda.ValueType.Boolean},
subscribed_to_site: {type: coda.ValueType.Boolean},
subscription_currency: {type: coda.ValueType.String},
subscription_frequency: {type: coda.ValueType.String},
subscription_price: {type: coda.ValueType.Number},
subscription_status: {type: coda.ValueType.String},
thumbnail: {type: coda.ValueType.String},
updated_at: {type: coda.ValueType.String, codaType: coda.ValueHintType.DateTime}
},
displayProperty: “name",
idProperty: “id",
featuredProperties: [”campaign", “coupon_code", "created_at", "email", "first_name", “id", “last_name", "last_payment_date", “location", “marketing_opt_in", "name", "next_payment_date", "pause_end_date", “plan", “platform", “promotion_code", "referrer", "registered_to_site", “subscribed_to_site", “subscription_currency", "subscription_frequency", "subscription_price", “subscription_status", "thumbnail", "updated_at"]
})
There are no rows in this table
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.