Share
Explore

icon picker
Draft Coda Schema

Building schemas can be a nightmare - No longer! Just input your JSON below watch the magic happen.
info

Magic not working for you yet?

This template uses AI to draft coda schemas for packs - If you don’t have access to Coda AI yet, you can sign up with the button below
Copy this doc
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
)

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.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.