Skip to main content
Glama

Make an artifact

make_artifact

Makes a file the person keeps: an Excel workbook, a Word document or a PowerPoint deck. It is kept in their artifacts, where they open and download it. Use it when they ask for a file, a spreadsheet, a memo, a deck, or to put something in Excel, Word or PowerPoint. Give recipe whenever the request is one of the house shapes (a buyer list, precedent deals, a firm profile, a deal brief, a sector report or deck): its parts are fixed, and you fill them. A table of records is filled by the server, not typed: give the table table (a house table, which brings its own columns) and from (a lookup's tool name and arguments), and every page of the lookup becomes rows. Only a table no house table fits gives columns (a header and a value pattern each). Before a file is kept it is checked and read: if it would be sent back, you are told what to fix, once. A pattern is text with a row's fields in braces: {company}; {firm.name}; {parties[].name} (every item of a list, joined with commas); {parties[role=Buyer].name} (the items that match); {parties[firm_id!=ria-160711].name} (the items that do not: the other firms on a deal); {parties[0].name} (the first); {parties[]|each:$name ($role)} (each item written out); {date|year}; {parties|count}; and a record's name as a link to its page, {company}. A pattern that is one field keeps a number a number. To change an artifact, give its id as replaces with the whole new content. In words you type, write a record's name as a Markdown link to its page, name, so the file links to it.

Tool call template

Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.

{
  "id": 1,
  "jsonrpc": "2.0",
  "method": "tools/call",
  "params": {
    "arguments": {
      "kind": "<kind>",
      "title": "<title>"
    },
    "name": "make_artifact"
  }
}

Input Schema

NameRequiredDescriptionDefault
kindYesspreadsheet: an Excel workbook, for a table of records to sort and filter. document: a Word document, for a memo, a profile or a write-up. deck: a PowerPoint deck, for slides.
brandNoA company's domain, like acme.com, to set the file in that company's brand: its colours, its type and its logo, read from its own site. Give it when the person names a company or a site to style the file after, or asks for "our brand" and has said which site is theirs. "corridome" sets the plain look. Left out, the file takes the account's own brand when it has set one.
titleYesThe artifact's name as its owner will look for it: what it holds, in a few words. Not a file name.
blocksNoFor a document: its blocks, in order. The title is added above them. A table block is typed or filled from a lookup, as a sheet is.
recipeNoThe house shape the file follows. Use one whenever the request is of its kind: its parts and their order are checked before the file is kept. Leave it out only for a file none of these is. - buyer_list (spreadsheet): Who buys in a sector, a size or a period: a list of firms to call. Buyers: table "buyers". One row a firm that bought, the most active first. Deals: table "deals". The deals the list is counted from, filled from the same lookup. - precedent_deals (spreadsheet): The deals themselves, as a table to sort and filter: comparable sales, a sector's deals, a firm's deals. Deals: table "deals". One row a deal, newest first. By year (optional): table "deals_by_year". The same lookup, counted by year. - people_list (spreadsheet): People to reach: by title, firm, kind of firm or state. People: table "people". One row a person. - fund_list (spreadsheet): A firm's funds, or the funds of one type. Funds: table "funds". One row a fund, the largest first. - firm_profile (document): One firm on one page: what it is, what it manages, what it has done. Opens with a paragraph: Two or three sentences: what the firm is, where, and the one thing about it this reader most needs. At a glance: facts. A two-column table, Fact and On file: its kind, location, identifiers, funds and gross assets, deals on file, the date of its latest filing. Only what the record states. Funds (optional): table "funds", max 10. Its largest funds, from get_firm. Recent deals (optional): table "firm_deals", max 10. Its latest deals, from get_firm or a deals lookup for this firm. Portfolio (optional): table "companies", max 12. The companies it holds, from get_firm. People (optional): table "people", max 12. The people on its record. - deal_brief (document): One deal on one page: who, what, when, how much, who advised. Opens with a paragraph: Two or three sentences: who bought what from whom, when, and for how much if it is on file. Parties: table "parties". Each firm's part on the deal, from get_deal. Terms: facts. A two-column table, Term and On file: the value and what it measures, the date announced, the type, the status, the filing it is read from. The company (optional): words. A short paragraph on the company, and who has owned it. Other deals for the company (optional): table "deals", max 8. From get_deal. - sector_report (document): A sector's deals written up: how active, who buys, who advises, what happened lately. Opens with a paragraph: Three sentences at most: how many deals over what years, who buys most, and who advises most. Figures only from the tables below. Deal activity: table "deals_by_year". The sector's deals counted by year. Most active buyers: table "buyers", max 10. The same lookup, one row a buyer. Sellers' advisers: table "advisers", max 10. The same lookup, one row a bank. Recent deals: table "deals", max 15. The newest deals in the sector. - sector_deck (deck): A sector's deals as slides, for a meeting. What the slides say: bullets. Three to five bullets, each one finding with its figure. Activity by year: table "deals_by_year". The sector's deals counted by year. Who buys: table "buyers", max 8. The most active buyers. Who advises sellers: table "advisers", max 8. The most active sellers' advisers. The latest deals: table "deals", max 8. The newest eight.
sheetsNoFor a spreadsheet: its sheets. One row a record, one fact a cell. A number that is a number goes in as a number, never as text.
slidesNoFor a deck: its slides, in order. A slide's title is its finding in a short sentence with its figure, never a topic. Under it: bullets (six at most, one finding each), a table, or both. A slide's table holds ten rows and six columns at most: use a house table, and give its lookup `max`. A table that has a chart is shown on its slide as the chart, with at most three bullets beside it.
replacesNoTo change an artifact: its id. The content you give replaces it whole, as a new version. Leave out to make a new artifact.

Schema Changelog

Changes observed during successful MCP inspections.

  1. Changed3 schema fields changed
    • changedInput schema / properties / blocks / items / properties / table / description
      Previous value: -"The house table to use: its columns, their order and their formats are the system's, so you give only `from` and never `columns`. Use one whenever the rows are of its kind. \"deals\": Deals, one a row: company, date, type, sector, the firms on each side, the value. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firm_deals\": One firm's deals, with the part the firm played on each. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"buyers\": A buyer list: one row a firm that bought, with how many deals, the latest, and what it bought. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"advisers\": Sellers' advisers: one row a bank, with how many sales it advised, the latest, and the companies sold. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"deals_by_year\": Deal activity: one row a year, with the deals in it and how many state a value. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firms\": Firms, one a row: name, kind, where. Filled from search_firms, get_firm, get_deal. \"funds\": Private funds, one a row: name, type, adviser, gross asset value and its date. Filled from get_firm, list_funds. \"companies\": Portfolio companies, one a row: name, sector, status, since when, owner. Filled from get_firm, list_companies. \"new_offerings\": Form D offerings by the day they were first filed, one a row: issuer, place, first filed, what it is, its terms, whether a firm is named as paid for sales, who signed, the people named and the issuer's phone. Filled from find_offerings. \"found_buyers\": Buyers of companies of a kind, one a row, the most active first: the buyer, its kind and place, how many matching deals it did, its latest, the companies it bought, and with include_contacts its mailboxes and phone lines. Filled from find_buyers, which takes every word and sector at once. Filled from find_buyers. \"placement_agents\": Firms that issuers paid to sell offerings of one kind, one a row: firm, kind, place, how many matching offerings named it, how many under Rule 506(c), its latest notice, its mailboxes and phone lines, how many people are on file. Filled from find_placement_agents. \"found_companies\": Companies found by sector and size, one a row: name, place, NAICS code and industry, staff, founded, PPP loan, the owner or officer named, and for a member the company's phone and e-mail and a named person's own line. Filled from find_companies. \"people\": People, one a row: name, title, firm, state, and their contact details where the lookup opened them. Filled from search_people, get_firm. \"parties\": The firms on one deal: each one's part, and its name. Filled from get_deal."New value: +"The house table to use: its columns, their order and their formats are the system's, so you give only `from` and never `columns`. Use one whenever the rows are of its kind. \"deals\": Deals, one a row: company, date, type, sector, the firms on each side, the value. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firm_deals\": One firm's deals, with the part the firm played on each. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"buyers\": A buyer list: one row a firm that bought, with how many deals, the latest, and what it bought. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"advisers\": Sellers' advisers: one row a bank, with how many sales it advised, the latest, and the companies sold. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"deals_by_year\": Deal activity: one row a year, with the deals in it and how many state a value. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firms\": Firms, one a row: name, kind, where. Filled from search_firms, get_firm, get_deal. \"funds\": Private funds, one a row: name, type, adviser, gross asset value and its date. Filled from get_firm, list_funds. \"companies\": Portfolio companies, one a row: name, sector, status, since when, owner. Filled from get_firm, list_companies. \"new_offerings\": Form D offerings by the day they were first filed, one a row: issuer, place, first filed, what it is, its terms, whether a firm is named as paid for sales, who signed, the people named, and the issuer's phone where include_contacts opened it. Filled from find_offerings. \"found_buyers\": Buyers of companies of a kind, one a row, the most active first: the buyer, its kind and place, how many matching deals it did, its latest, the companies it bought, and with include_contacts its mailboxes and phone lines. Filled from find_buyers, which takes every word and sector at once. Filled from find_buyers. \"placement_agents\": Firms that issuers paid to sell offerings of one kind, one a row: firm, kind, place, how many matching offerings named it, how many under Rule 506(c), its latest notice, its mailboxes and phone lines where include_contacts opened them, how many people are on file. Filled from find_placement_agents. \"found_companies\": Companies found by sector and size, one a row: name, place, NAICS code and industry, staff, founded, PPP loan, the owner or officer named, which contacts its records give, and the company's phone and e-mail and a named person's own line where include_contacts opened them. Filled from find_companies. \"people\": People, one a row: name, title, firm, state, and their contact details where the lookup opened them. Filled from search_people, get_firm. \"parties\": The firms on one deal: each one's part, and its name. Filled from get_deal."
    • changedInput schema / properties / sheets / items / properties / table / description
      Previous value: -"The house table to use: its columns, their order and their formats are the system's, so you give only `from` and never `columns`. Use one whenever the rows are of its kind. \"deals\": Deals, one a row: company, date, type, sector, the firms on each side, the value. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firm_deals\": One firm's deals, with the part the firm played on each. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"buyers\": A buyer list: one row a firm that bought, with how many deals, the latest, and what it bought. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"advisers\": Sellers' advisers: one row a bank, with how many sales it advised, the latest, and the companies sold. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"deals_by_year\": Deal activity: one row a year, with the deals in it and how many state a value. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firms\": Firms, one a row: name, kind, where. Filled from search_firms, get_firm, get_deal. \"funds\": Private funds, one a row: name, type, adviser, gross asset value and its date. Filled from get_firm, list_funds. \"companies\": Portfolio companies, one a row: name, sector, status, since when, owner. Filled from get_firm, list_companies. \"new_offerings\": Form D offerings by the day they were first filed, one a row: issuer, place, first filed, what it is, its terms, whether a firm is named as paid for sales, who signed, the people named and the issuer's phone. Filled from find_offerings. \"found_buyers\": Buyers of companies of a kind, one a row, the most active first: the buyer, its kind and place, how many matching deals it did, its latest, the companies it bought, and with include_contacts its mailboxes and phone lines. Filled from find_buyers, which takes every word and sector at once. Filled from find_buyers. \"placement_agents\": Firms that issuers paid to sell offerings of one kind, one a row: firm, kind, place, how many matching offerings named it, how many under Rule 506(c), its latest notice, its mailboxes and phone lines, how many people are on file. Filled from find_placement_agents. \"found_companies\": Companies found by sector and size, one a row: name, place, NAICS code and industry, staff, founded, PPP loan, the owner or officer named, and for a member the company's phone and e-mail and a named person's own line. Filled from find_companies. \"people\": People, one a row: name, title, firm, state, and their contact details where the lookup opened them. Filled from search_people, get_firm. \"parties\": The firms on one deal: each one's part, and its name. Filled from get_deal."New value: +"The house table to use: its columns, their order and their formats are the system's, so you give only `from` and never `columns`. Use one whenever the rows are of its kind. \"deals\": Deals, one a row: company, date, type, sector, the firms on each side, the value. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firm_deals\": One firm's deals, with the part the firm played on each. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"buyers\": A buyer list: one row a firm that bought, with how many deals, the latest, and what it bought. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"advisers\": Sellers' advisers: one row a bank, with how many sales it advised, the latest, and the companies sold. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"deals_by_year\": Deal activity: one row a year, with the deals in it and how many state a value. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firms\": Firms, one a row: name, kind, where. Filled from search_firms, get_firm, get_deal. \"funds\": Private funds, one a row: name, type, adviser, gross asset value and its date. Filled from get_firm, list_funds. \"companies\": Portfolio companies, one a row: name, sector, status, since when, owner. Filled from get_firm, list_companies. \"new_offerings\": Form D offerings by the day they were first filed, one a row: issuer, place, first filed, what it is, its terms, whether a firm is named as paid for sales, who signed, the people named, and the issuer's phone where include_contacts opened it. Filled from find_offerings. \"found_buyers\": Buyers of companies of a kind, one a row, the most active first: the buyer, its kind and place, how many matching deals it did, its latest, the companies it bought, and with include_contacts its mailboxes and phone lines. Filled from find_buyers, which takes every word and sector at once. Filled from find_buyers. \"placement_agents\": Firms that issuers paid to sell offerings of one kind, one a row: firm, kind, place, how many matching offerings named it, how many under Rule 506(c), its latest notice, its mailboxes and phone lines where include_contacts opened them, how many people are on file. Filled from find_placement_agents. \"found_companies\": Companies found by sector and size, one a row: name, place, NAICS code and industry, staff, founded, PPP loan, the owner or officer named, which contacts its records give, and the company's phone and e-mail and a named person's own line where include_contacts opened them. Filled from find_companies. \"people\": People, one a row: name, title, firm, state, and their contact details where the lookup opened them. Filled from search_people, get_firm. \"parties\": The firms on one deal: each one's part, and its name. Filled from get_deal."
    • changedInput schema / properties / slides / items / properties / table / properties / table / description
      Previous value: -"The house table to use: its columns, their order and their formats are the system's, so you give only `from` and never `columns`. Use one whenever the rows are of its kind. \"deals\": Deals, one a row: company, date, type, sector, the firms on each side, the value. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firm_deals\": One firm's deals, with the part the firm played on each. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"buyers\": A buyer list: one row a firm that bought, with how many deals, the latest, and what it bought. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"advisers\": Sellers' advisers: one row a bank, with how many sales it advised, the latest, and the companies sold. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"deals_by_year\": Deal activity: one row a year, with the deals in it and how many state a value. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firms\": Firms, one a row: name, kind, where. Filled from search_firms, get_firm, get_deal. \"funds\": Private funds, one a row: name, type, adviser, gross asset value and its date. Filled from get_firm, list_funds. \"companies\": Portfolio companies, one a row: name, sector, status, since when, owner. Filled from get_firm, list_companies. \"new_offerings\": Form D offerings by the day they were first filed, one a row: issuer, place, first filed, what it is, its terms, whether a firm is named as paid for sales, who signed, the people named and the issuer's phone. Filled from find_offerings. \"found_buyers\": Buyers of companies of a kind, one a row, the most active first: the buyer, its kind and place, how many matching deals it did, its latest, the companies it bought, and with include_contacts its mailboxes and phone lines. Filled from find_buyers, which takes every word and sector at once. Filled from find_buyers. \"placement_agents\": Firms that issuers paid to sell offerings of one kind, one a row: firm, kind, place, how many matching offerings named it, how many under Rule 506(c), its latest notice, its mailboxes and phone lines, how many people are on file. Filled from find_placement_agents. \"found_companies\": Companies found by sector and size, one a row: name, place, NAICS code and industry, staff, founded, PPP loan, the owner or officer named, and for a member the company's phone and e-mail and a named person's own line. Filled from find_companies. \"people\": People, one a row: name, title, firm, state, and their contact details where the lookup opened them. Filled from search_people, get_firm. \"parties\": The firms on one deal: each one's part, and its name. Filled from get_deal."New value: +"The house table to use: its columns, their order and their formats are the system's, so you give only `from` and never `columns`. Use one whenever the rows are of its kind. \"deals\": Deals, one a row: company, date, type, sector, the firms on each side, the value. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firm_deals\": One firm's deals, with the part the firm played on each. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"buyers\": A buyer list: one row a firm that bought, with how many deals, the latest, and what it bought. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"advisers\": Sellers' advisers: one row a bank, with how many sales it advised, the latest, and the companies sold. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"deals_by_year\": Deal activity: one row a year, with the deals in it and how many state a value. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firms\": Firms, one a row: name, kind, where. Filled from search_firms, get_firm, get_deal. \"funds\": Private funds, one a row: name, type, adviser, gross asset value and its date. Filled from get_firm, list_funds. \"companies\": Portfolio companies, one a row: name, sector, status, since when, owner. Filled from get_firm, list_companies. \"new_offerings\": Form D offerings by the day they were first filed, one a row: issuer, place, first filed, what it is, its terms, whether a firm is named as paid for sales, who signed, the people named, and the issuer's phone where include_contacts opened it. Filled from find_offerings. \"found_buyers\": Buyers of companies of a kind, one a row, the most active first: the buyer, its kind and place, how many matching deals it did, its latest, the companies it bought, and with include_contacts its mailboxes and phone lines. Filled from find_buyers, which takes every word and sector at once. Filled from find_buyers. \"placement_agents\": Firms that issuers paid to sell offerings of one kind, one a row: firm, kind, place, how many matching offerings named it, how many under Rule 506(c), its latest notice, its mailboxes and phone lines where include_contacts opened them, how many people are on file. Filled from find_placement_agents. \"found_companies\": Companies found by sector and size, one a row: name, place, NAICS code and industry, staff, founded, PPP loan, the owner or officer named, which contacts its records give, and the company's phone and e-mail and a named person's own line where include_contacts opened them. Filled from find_companies. \"people\": People, one a row: name, title, firm, state, and their contact details where the lookup opened them. Filled from search_people, get_firm. \"parties\": The firms on one deal: each one's part, and its name. Filled from get_deal."
  2. Changed6 schema fields changed
    • changedInput schema / properties / blocks / items / properties / table / description
      Previous value: -"The house table to use: its columns, their order and their formats are the system's, so you give only `from` and never `columns`. Use one whenever the rows are of its kind. \"deals\": Deals, one a row: company, date, type, sector, the firms on each side, the value. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firm_deals\": One firm's deals, with the part the firm played on each. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"buyers\": A buyer list: one row a firm that bought, with how many deals, the latest, and what it bought. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"advisers\": Sellers' advisers: one row a bank, with how many sales it advised, the latest, and the companies sold. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"deals_by_year\": Deal activity: one row a year, with the deals in it and how many state a value. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firms\": Firms, one a row: name, kind, where. Filled from search_firms, get_firm, get_deal. \"funds\": Private funds, one a row: name, type, adviser, gross asset value and its date. Filled from get_firm, list_funds. \"companies\": Portfolio companies, one a row: name, sector, status, since when, owner. Filled from get_firm, list_companies. \"new_offerings\": Form D offerings by the day they were first filed, one a row: issuer, place, first filed, what it is, its terms, whether a firm is named as paid for sales, who signed, the people named and the issuer's phone. Filled from find_offerings. \"placement_agents\": Firms that issuers paid to sell offerings of one kind, one a row: firm, kind, place, how many matching offerings named it, how many under Rule 506(c), its latest notice, its mailboxes and phone lines, how many people are on file. Filled from find_placement_agents. \"found_companies\": Companies found by sector and size, one a row: name, place, NAICS code and industry, staff, founded, PPP loan, the owner or officer named, and for a member the company's phone and e-mail and a named person's own line. Filled from find_companies. \"people\": People, one a row: name, title, firm, state, and their contact details where the lookup opened them. Filled from search_people, get_firm. \"parties\": The firms on one deal: each one's part, and its name. Filled from get_deal."New value: +"The house table to use: its columns, their order and their formats are the system's, so you give only `from` and never `columns`. Use one whenever the rows are of its kind. \"deals\": Deals, one a row: company, date, type, sector, the firms on each side, the value. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firm_deals\": One firm's deals, with the part the firm played on each. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"buyers\": A buyer list: one row a firm that bought, with how many deals, the latest, and what it bought. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"advisers\": Sellers' advisers: one row a bank, with how many sales it advised, the latest, and the companies sold. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"deals_by_year\": Deal activity: one row a year, with the deals in it and how many state a value. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firms\": Firms, one a row: name, kind, where. Filled from search_firms, get_firm, get_deal. \"funds\": Private funds, one a row: name, type, adviser, gross asset value and its date. Filled from get_firm, list_funds. \"companies\": Portfolio companies, one a row: name, sector, status, since when, owner. Filled from get_firm, list_companies. \"new_offerings\": Form D offerings by the day they were first filed, one a row: issuer, place, first filed, what it is, its terms, whether a firm is named as paid for sales, who signed, the people named and the issuer's phone. Filled from find_offerings. \"found_buyers\": Buyers of companies of a kind, one a row, the most active first: the buyer, its kind and place, how many matching deals it did, its latest, the companies it bought, and with include_contacts its mailboxes and phone lines. Filled from find_buyers, which takes every word and sector at once. Filled from find_buyers. \"placement_agents\": Firms that issuers paid to sell offerings of one kind, one a row: firm, kind, place, how many matching offerings named it, how many under Rule 506(c), its latest notice, its mailboxes and phone lines, how many people are on file. Filled from find_placement_agents. \"found_companies\": Companies found by sector and size, one a row: name, place, NAICS code and industry, staff, founded, PPP loan, the owner or officer named, and for a member the company's phone and e-mail and a named person's own line. Filled from find_companies. \"people\": People, one a row: name, title, firm, state, and their contact details where the lookup opened them. Filled from search_people, get_firm. \"parties\": The firms on one deal: each one's part, and its name. Filled from get_deal."
    • changedInput schema / properties / blocks / items / properties / table / enum
      Previous value: -[
      -  "deals",
      -  "firm_deals",
      -  "buyers",
      -  "advisers",
      -  "deals_by_year",
      -  "firms",
      -  "funds",
      -  "companies",
      -  "new_offerings",
      -  "placement_agents",
      -  "found_companies",
      -  "people",
      -  "parties"
      -]New value: +[
      +  "deals",
      +  "firm_deals",
      +  "buyers",
      +  "advisers",
      +  "deals_by_year",
      +  "firms",
      +  "funds",
      +  "companies",
      +  "new_offerings",
      +  "found_buyers",
      +  "placement_agents",
      +  "found_companies",
      +  "people",
      +  "parties"
      +]
    • changedInput schema / properties / sheets / items / properties / table / description
      Previous value: -"The house table to use: its columns, their order and their formats are the system's, so you give only `from` and never `columns`. Use one whenever the rows are of its kind. \"deals\": Deals, one a row: company, date, type, sector, the firms on each side, the value. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firm_deals\": One firm's deals, with the part the firm played on each. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"buyers\": A buyer list: one row a firm that bought, with how many deals, the latest, and what it bought. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"advisers\": Sellers' advisers: one row a bank, with how many sales it advised, the latest, and the companies sold. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"deals_by_year\": Deal activity: one row a year, with the deals in it and how many state a value. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firms\": Firms, one a row: name, kind, where. Filled from search_firms, get_firm, get_deal. \"funds\": Private funds, one a row: name, type, adviser, gross asset value and its date. Filled from get_firm, list_funds. \"companies\": Portfolio companies, one a row: name, sector, status, since when, owner. Filled from get_firm, list_companies. \"new_offerings\": Form D offerings by the day they were first filed, one a row: issuer, place, first filed, what it is, its terms, whether a firm is named as paid for sales, who signed, the people named and the issuer's phone. Filled from find_offerings. \"placement_agents\": Firms that issuers paid to sell offerings of one kind, one a row: firm, kind, place, how many matching offerings named it, how many under Rule 506(c), its latest notice, its mailboxes and phone lines, how many people are on file. Filled from find_placement_agents. \"found_companies\": Companies found by sector and size, one a row: name, place, NAICS code and industry, staff, founded, PPP loan, the owner or officer named, and for a member the company's phone and e-mail and a named person's own line. Filled from find_companies. \"people\": People, one a row: name, title, firm, state, and their contact details where the lookup opened them. Filled from search_people, get_firm. \"parties\": The firms on one deal: each one's part, and its name. Filled from get_deal."New value: +"The house table to use: its columns, their order and their formats are the system's, so you give only `from` and never `columns`. Use one whenever the rows are of its kind. \"deals\": Deals, one a row: company, date, type, sector, the firms on each side, the value. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firm_deals\": One firm's deals, with the part the firm played on each. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"buyers\": A buyer list: one row a firm that bought, with how many deals, the latest, and what it bought. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"advisers\": Sellers' advisers: one row a bank, with how many sales it advised, the latest, and the companies sold. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"deals_by_year\": Deal activity: one row a year, with the deals in it and how many state a value. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firms\": Firms, one a row: name, kind, where. Filled from search_firms, get_firm, get_deal. \"funds\": Private funds, one a row: name, type, adviser, gross asset value and its date. Filled from get_firm, list_funds. \"companies\": Portfolio companies, one a row: name, sector, status, since when, owner. Filled from get_firm, list_companies. \"new_offerings\": Form D offerings by the day they were first filed, one a row: issuer, place, first filed, what it is, its terms, whether a firm is named as paid for sales, who signed, the people named and the issuer's phone. Filled from find_offerings. \"found_buyers\": Buyers of companies of a kind, one a row, the most active first: the buyer, its kind and place, how many matching deals it did, its latest, the companies it bought, and with include_contacts its mailboxes and phone lines. Filled from find_buyers, which takes every word and sector at once. Filled from find_buyers. \"placement_agents\": Firms that issuers paid to sell offerings of one kind, one a row: firm, kind, place, how many matching offerings named it, how many under Rule 506(c), its latest notice, its mailboxes and phone lines, how many people are on file. Filled from find_placement_agents. \"found_companies\": Companies found by sector and size, one a row: name, place, NAICS code and industry, staff, founded, PPP loan, the owner or officer named, and for a member the company's phone and e-mail and a named person's own line. Filled from find_companies. \"people\": People, one a row: name, title, firm, state, and their contact details where the lookup opened them. Filled from search_people, get_firm. \"parties\": The firms on one deal: each one's part, and its name. Filled from get_deal."
    • changedInput schema / properties / sheets / items / properties / table / enum
      Previous value: -[
      -  "deals",
      -  "firm_deals",
      -  "buyers",
      -  "advisers",
      -  "deals_by_year",
      -  "firms",
      -  "funds",
      -  "companies",
      -  "new_offerings",
      -  "placement_agents",
      -  "found_companies",
      -  "people",
      -  "parties"
      -]New value: +[
      +  "deals",
      +  "firm_deals",
      +  "buyers",
      +  "advisers",
      +  "deals_by_year",
      +  "firms",
      +  "funds",
      +  "companies",
      +  "new_offerings",
      +  "found_buyers",
      +  "placement_agents",
      +  "found_companies",
      +  "people",
      +  "parties"
      +]
    • changedInput schema / properties / slides / items / properties / table / properties / table / description
      Previous value: -"The house table to use: its columns, their order and their formats are the system's, so you give only `from` and never `columns`. Use one whenever the rows are of its kind. \"deals\": Deals, one a row: company, date, type, sector, the firms on each side, the value. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firm_deals\": One firm's deals, with the part the firm played on each. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"buyers\": A buyer list: one row a firm that bought, with how many deals, the latest, and what it bought. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"advisers\": Sellers' advisers: one row a bank, with how many sales it advised, the latest, and the companies sold. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"deals_by_year\": Deal activity: one row a year, with the deals in it and how many state a value. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firms\": Firms, one a row: name, kind, where. Filled from search_firms, get_firm, get_deal. \"funds\": Private funds, one a row: name, type, adviser, gross asset value and its date. Filled from get_firm, list_funds. \"companies\": Portfolio companies, one a row: name, sector, status, since when, owner. Filled from get_firm, list_companies. \"new_offerings\": Form D offerings by the day they were first filed, one a row: issuer, place, first filed, what it is, its terms, whether a firm is named as paid for sales, who signed, the people named and the issuer's phone. Filled from find_offerings. \"placement_agents\": Firms that issuers paid to sell offerings of one kind, one a row: firm, kind, place, how many matching offerings named it, how many under Rule 506(c), its latest notice, its mailboxes and phone lines, how many people are on file. Filled from find_placement_agents. \"found_companies\": Companies found by sector and size, one a row: name, place, NAICS code and industry, staff, founded, PPP loan, the owner or officer named, and for a member the company's phone and e-mail and a named person's own line. Filled from find_companies. \"people\": People, one a row: name, title, firm, state, and their contact details where the lookup opened them. Filled from search_people, get_firm. \"parties\": The firms on one deal: each one's part, and its name. Filled from get_deal."New value: +"The house table to use: its columns, their order and their formats are the system's, so you give only `from` and never `columns`. Use one whenever the rows are of its kind. \"deals\": Deals, one a row: company, date, type, sector, the firms on each side, the value. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firm_deals\": One firm's deals, with the part the firm played on each. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"buyers\": A buyer list: one row a firm that bought, with how many deals, the latest, and what it bought. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"advisers\": Sellers' advisers: one row a bank, with how many sales it advised, the latest, and the companies sold. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"deals_by_year\": Deal activity: one row a year, with the deals in it and how many state a value. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firms\": Firms, one a row: name, kind, where. Filled from search_firms, get_firm, get_deal. \"funds\": Private funds, one a row: name, type, adviser, gross asset value and its date. Filled from get_firm, list_funds. \"companies\": Portfolio companies, one a row: name, sector, status, since when, owner. Filled from get_firm, list_companies. \"new_offerings\": Form D offerings by the day they were first filed, one a row: issuer, place, first filed, what it is, its terms, whether a firm is named as paid for sales, who signed, the people named and the issuer's phone. Filled from find_offerings. \"found_buyers\": Buyers of companies of a kind, one a row, the most active first: the buyer, its kind and place, how many matching deals it did, its latest, the companies it bought, and with include_contacts its mailboxes and phone lines. Filled from find_buyers, which takes every word and sector at once. Filled from find_buyers. \"placement_agents\": Firms that issuers paid to sell offerings of one kind, one a row: firm, kind, place, how many matching offerings named it, how many under Rule 506(c), its latest notice, its mailboxes and phone lines, how many people are on file. Filled from find_placement_agents. \"found_companies\": Companies found by sector and size, one a row: name, place, NAICS code and industry, staff, founded, PPP loan, the owner or officer named, and for a member the company's phone and e-mail and a named person's own line. Filled from find_companies. \"people\": People, one a row: name, title, firm, state, and their contact details where the lookup opened them. Filled from search_people, get_firm. \"parties\": The firms on one deal: each one's part, and its name. Filled from get_deal."
    • changedInput schema / properties / slides / items / properties / table / properties / table / enum
      Previous value: -[
      -  "deals",
      -  "firm_deals",
      -  "buyers",
      -  "advisers",
      -  "deals_by_year",
      -  "firms",
      -  "funds",
      -  "companies",
      -  "new_offerings",
      -  "placement_agents",
      -  "found_companies",
      -  "people",
      -  "parties"
      -]New value: +[
      +  "deals",
      +  "firm_deals",
      +  "buyers",
      +  "advisers",
      +  "deals_by_year",
      +  "firms",
      +  "funds",
      +  "companies",
      +  "new_offerings",
      +  "found_buyers",
      +  "placement_agents",
      +  "found_companies",
      +  "people",
      +  "parties"
      +]
  3. Changed6 schema fields changed
    • changedInput schema / properties / blocks / items / properties / table / description
      Previous value: -"The house table to use: its columns, their order and their formats are the system's, so you give only `from` and never `columns`. Use one whenever the rows are of its kind. \"deals\": Deals, one a row: company, date, type, sector, the firms on each side, the value. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firm_deals\": One firm's deals, with the part the firm played on each. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"buyers\": A buyer list: one row a firm that bought, with how many deals, the latest, and what it bought. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"advisers\": Sellers' advisers: one row a bank, with how many sales it advised, the latest, and the companies sold. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"deals_by_year\": Deal activity: one row a year, with the deals in it and how many state a value. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firms\": Firms, one a row: name, kind, where. Filled from search_firms, get_firm, get_deal. \"funds\": Private funds, one a row: name, type, adviser, gross asset value and its date. Filled from get_firm, list_funds. \"companies\": Portfolio companies, one a row: name, sector, status, since when, owner. Filled from get_firm, list_companies. \"found_companies\": Companies found by sector and size, one a row: name, place, NAICS code and industry, staff, founded, PPP loan, the owner or officer named. Filled from find_companies. \"people\": People, one a row: name, title, firm, state, and their contact details where the lookup opened them. Filled from search_people, get_firm. \"parties\": The firms on one deal: each one's part, and its name. Filled from get_deal."New value: +"The house table to use: its columns, their order and their formats are the system's, so you give only `from` and never `columns`. Use one whenever the rows are of its kind. \"deals\": Deals, one a row: company, date, type, sector, the firms on each side, the value. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firm_deals\": One firm's deals, with the part the firm played on each. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"buyers\": A buyer list: one row a firm that bought, with how many deals, the latest, and what it bought. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"advisers\": Sellers' advisers: one row a bank, with how many sales it advised, the latest, and the companies sold. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"deals_by_year\": Deal activity: one row a year, with the deals in it and how many state a value. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firms\": Firms, one a row: name, kind, where. Filled from search_firms, get_firm, get_deal. \"funds\": Private funds, one a row: name, type, adviser, gross asset value and its date. Filled from get_firm, list_funds. \"companies\": Portfolio companies, one a row: name, sector, status, since when, owner. Filled from get_firm, list_companies. \"new_offerings\": Form D offerings by the day they were first filed, one a row: issuer, place, first filed, what it is, its terms, whether a firm is named as paid for sales, who signed, the people named and the issuer's phone. Filled from find_offerings. \"placement_agents\": Firms that issuers paid to sell offerings of one kind, one a row: firm, kind, place, how many matching offerings named it, how many under Rule 506(c), its latest notice, its mailboxes and phone lines, how many people are on file. Filled from find_placement_agents. \"found_companies\": Companies found by sector and size, one a row: name, place, NAICS code and industry, staff, founded, PPP loan, the owner or officer named, and for a member the company's phone and e-mail and a named person's own line. Filled from find_companies. \"people\": People, one a row: name, title, firm, state, and their contact details where the lookup opened them. Filled from search_people, get_firm. \"parties\": The firms on one deal: each one's part, and its name. Filled from get_deal."
    • changedInput schema / properties / blocks / items / properties / table / enum
      Previous value: -[
      -  "deals",
      -  "firm_deals",
      -  "buyers",
      -  "advisers",
      -  "deals_by_year",
      -  "firms",
      -  "funds",
      -  "companies",
      -  "found_companies",
      -  "people",
      -  "parties"
      -]New value: +[
      +  "deals",
      +  "firm_deals",
      +  "buyers",
      +  "advisers",
      +  "deals_by_year",
      +  "firms",
      +  "funds",
      +  "companies",
      +  "new_offerings",
      +  "placement_agents",
      +  "found_companies",
      +  "people",
      +  "parties"
      +]
    • changedInput schema / properties / sheets / items / properties / table / description
      Previous value: -"The house table to use: its columns, their order and their formats are the system's, so you give only `from` and never `columns`. Use one whenever the rows are of its kind. \"deals\": Deals, one a row: company, date, type, sector, the firms on each side, the value. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firm_deals\": One firm's deals, with the part the firm played on each. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"buyers\": A buyer list: one row a firm that bought, with how many deals, the latest, and what it bought. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"advisers\": Sellers' advisers: one row a bank, with how many sales it advised, the latest, and the companies sold. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"deals_by_year\": Deal activity: one row a year, with the deals in it and how many state a value. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firms\": Firms, one a row: name, kind, where. Filled from search_firms, get_firm, get_deal. \"funds\": Private funds, one a row: name, type, adviser, gross asset value and its date. Filled from get_firm, list_funds. \"companies\": Portfolio companies, one a row: name, sector, status, since when, owner. Filled from get_firm, list_companies. \"found_companies\": Companies found by sector and size, one a row: name, place, NAICS code and industry, staff, founded, PPP loan, the owner or officer named. Filled from find_companies. \"people\": People, one a row: name, title, firm, state, and their contact details where the lookup opened them. Filled from search_people, get_firm. \"parties\": The firms on one deal: each one's part, and its name. Filled from get_deal."New value: +"The house table to use: its columns, their order and their formats are the system's, so you give only `from` and never `columns`. Use one whenever the rows are of its kind. \"deals\": Deals, one a row: company, date, type, sector, the firms on each side, the value. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firm_deals\": One firm's deals, with the part the firm played on each. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"buyers\": A buyer list: one row a firm that bought, with how many deals, the latest, and what it bought. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"advisers\": Sellers' advisers: one row a bank, with how many sales it advised, the latest, and the companies sold. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"deals_by_year\": Deal activity: one row a year, with the deals in it and how many state a value. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firms\": Firms, one a row: name, kind, where. Filled from search_firms, get_firm, get_deal. \"funds\": Private funds, one a row: name, type, adviser, gross asset value and its date. Filled from get_firm, list_funds. \"companies\": Portfolio companies, one a row: name, sector, status, since when, owner. Filled from get_firm, list_companies. \"new_offerings\": Form D offerings by the day they were first filed, one a row: issuer, place, first filed, what it is, its terms, whether a firm is named as paid for sales, who signed, the people named and the issuer's phone. Filled from find_offerings. \"placement_agents\": Firms that issuers paid to sell offerings of one kind, one a row: firm, kind, place, how many matching offerings named it, how many under Rule 506(c), its latest notice, its mailboxes and phone lines, how many people are on file. Filled from find_placement_agents. \"found_companies\": Companies found by sector and size, one a row: name, place, NAICS code and industry, staff, founded, PPP loan, the owner or officer named, and for a member the company's phone and e-mail and a named person's own line. Filled from find_companies. \"people\": People, one a row: name, title, firm, state, and their contact details where the lookup opened them. Filled from search_people, get_firm. \"parties\": The firms on one deal: each one's part, and its name. Filled from get_deal."
    • changedInput schema / properties / sheets / items / properties / table / enum
      Previous value: -[
      -  "deals",
      -  "firm_deals",
      -  "buyers",
      -  "advisers",
      -  "deals_by_year",
      -  "firms",
      -  "funds",
      -  "companies",
      -  "found_companies",
      -  "people",
      -  "parties"
      -]New value: +[
      +  "deals",
      +  "firm_deals",
      +  "buyers",
      +  "advisers",
      +  "deals_by_year",
      +  "firms",
      +  "funds",
      +  "companies",
      +  "new_offerings",
      +  "placement_agents",
      +  "found_companies",
      +  "people",
      +  "parties"
      +]
    • changedInput schema / properties / slides / items / properties / table / properties / table / description
      Previous value: -"The house table to use: its columns, their order and their formats are the system's, so you give only `from` and never `columns`. Use one whenever the rows are of its kind. \"deals\": Deals, one a row: company, date, type, sector, the firms on each side, the value. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firm_deals\": One firm's deals, with the part the firm played on each. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"buyers\": A buyer list: one row a firm that bought, with how many deals, the latest, and what it bought. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"advisers\": Sellers' advisers: one row a bank, with how many sales it advised, the latest, and the companies sold. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"deals_by_year\": Deal activity: one row a year, with the deals in it and how many state a value. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firms\": Firms, one a row: name, kind, where. Filled from search_firms, get_firm, get_deal. \"funds\": Private funds, one a row: name, type, adviser, gross asset value and its date. Filled from get_firm, list_funds. \"companies\": Portfolio companies, one a row: name, sector, status, since when, owner. Filled from get_firm, list_companies. \"found_companies\": Companies found by sector and size, one a row: name, place, NAICS code and industry, staff, founded, PPP loan, the owner or officer named. Filled from find_companies. \"people\": People, one a row: name, title, firm, state, and their contact details where the lookup opened them. Filled from search_people, get_firm. \"parties\": The firms on one deal: each one's part, and its name. Filled from get_deal."New value: +"The house table to use: its columns, their order and their formats are the system's, so you give only `from` and never `columns`. Use one whenever the rows are of its kind. \"deals\": Deals, one a row: company, date, type, sector, the firms on each side, the value. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firm_deals\": One firm's deals, with the part the firm played on each. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"buyers\": A buyer list: one row a firm that bought, with how many deals, the latest, and what it bought. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"advisers\": Sellers' advisers: one row a bank, with how many sales it advised, the latest, and the companies sold. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"deals_by_year\": Deal activity: one row a year, with the deals in it and how many state a value. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firms\": Firms, one a row: name, kind, where. Filled from search_firms, get_firm, get_deal. \"funds\": Private funds, one a row: name, type, adviser, gross asset value and its date. Filled from get_firm, list_funds. \"companies\": Portfolio companies, one a row: name, sector, status, since when, owner. Filled from get_firm, list_companies. \"new_offerings\": Form D offerings by the day they were first filed, one a row: issuer, place, first filed, what it is, its terms, whether a firm is named as paid for sales, who signed, the people named and the issuer's phone. Filled from find_offerings. \"placement_agents\": Firms that issuers paid to sell offerings of one kind, one a row: firm, kind, place, how many matching offerings named it, how many under Rule 506(c), its latest notice, its mailboxes and phone lines, how many people are on file. Filled from find_placement_agents. \"found_companies\": Companies found by sector and size, one a row: name, place, NAICS code and industry, staff, founded, PPP loan, the owner or officer named, and for a member the company's phone and e-mail and a named person's own line. Filled from find_companies. \"people\": People, one a row: name, title, firm, state, and their contact details where the lookup opened them. Filled from search_people, get_firm. \"parties\": The firms on one deal: each one's part, and its name. Filled from get_deal."
    • changedInput schema / properties / slides / items / properties / table / properties / table / enum
      Previous value: -[
      -  "deals",
      -  "firm_deals",
      -  "buyers",
      -  "advisers",
      -  "deals_by_year",
      -  "firms",
      -  "funds",
      -  "companies",
      -  "found_companies",
      -  "people",
      -  "parties"
      -]New value: +[
      +  "deals",
      +  "firm_deals",
      +  "buyers",
      +  "advisers",
      +  "deals_by_year",
      +  "firms",
      +  "funds",
      +  "companies",
      +  "new_offerings",
      +  "placement_agents",
      +  "found_companies",
      +  "people",
      +  "parties"
      +]
  4. Changed6 schema fields changed
    • changedInput schema / properties / blocks / items / properties / table / description
      Previous value: -"The house table to use: its columns, their order and their formats are the system's, so you give only `from` and never `columns`. Use one whenever the rows are of its kind. \"deals\": Deals, one a row: company, date, type, sector, the firms on each side, the value. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firm_deals\": One firm's deals, with the part the firm played on each. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"buyers\": A buyer list: one row a firm that bought, with how many deals, the latest, and what it bought. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"advisers\": Sellers' advisers: one row a bank, with how many sales it advised, the latest, and the companies sold. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"deals_by_year\": Deal activity: one row a year, with the deals in it and how many state a value. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firms\": Firms, one a row: name, kind, where. Filled from search_firms, get_firm, get_deal. \"funds\": Private funds, one a row: name, type, adviser, gross asset value and its date. Filled from get_firm, list_funds. \"companies\": Portfolio companies, one a row: name, sector, status, since when, owner. Filled from get_firm, list_companies. \"people\": People, one a row: name, title, firm, state, and their contact details where the lookup opened them. Filled from search_people, get_firm. \"parties\": The firms on one deal: each one's part, and its name. Filled from get_deal."New value: +"The house table to use: its columns, their order and their formats are the system's, so you give only `from` and never `columns`. Use one whenever the rows are of its kind. \"deals\": Deals, one a row: company, date, type, sector, the firms on each side, the value. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firm_deals\": One firm's deals, with the part the firm played on each. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"buyers\": A buyer list: one row a firm that bought, with how many deals, the latest, and what it bought. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"advisers\": Sellers' advisers: one row a bank, with how many sales it advised, the latest, and the companies sold. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"deals_by_year\": Deal activity: one row a year, with the deals in it and how many state a value. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firms\": Firms, one a row: name, kind, where. Filled from search_firms, get_firm, get_deal. \"funds\": Private funds, one a row: name, type, adviser, gross asset value and its date. Filled from get_firm, list_funds. \"companies\": Portfolio companies, one a row: name, sector, status, since when, owner. Filled from get_firm, list_companies. \"found_companies\": Companies found by sector and size, one a row: name, place, NAICS code and industry, staff, founded, PPP loan, the owner or officer named. Filled from find_companies. \"people\": People, one a row: name, title, firm, state, and their contact details where the lookup opened them. Filled from search_people, get_firm. \"parties\": The firms on one deal: each one's part, and its name. Filled from get_deal."
    • changedInput schema / properties / blocks / items / properties / table / enum
      Previous value: -[
      -  "deals",
      -  "firm_deals",
      -  "buyers",
      -  "advisers",
      -  "deals_by_year",
      -  "firms",
      -  "funds",
      -  "companies",
      -  "people",
      -  "parties"
      -]New value: +[
      +  "deals",
      +  "firm_deals",
      +  "buyers",
      +  "advisers",
      +  "deals_by_year",
      +  "firms",
      +  "funds",
      +  "companies",
      +  "found_companies",
      +  "people",
      +  "parties"
      +]
    • changedInput schema / properties / sheets / items / properties / table / description
      Previous value: -"The house table to use: its columns, their order and their formats are the system's, so you give only `from` and never `columns`. Use one whenever the rows are of its kind. \"deals\": Deals, one a row: company, date, type, sector, the firms on each side, the value. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firm_deals\": One firm's deals, with the part the firm played on each. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"buyers\": A buyer list: one row a firm that bought, with how many deals, the latest, and what it bought. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"advisers\": Sellers' advisers: one row a bank, with how many sales it advised, the latest, and the companies sold. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"deals_by_year\": Deal activity: one row a year, with the deals in it and how many state a value. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firms\": Firms, one a row: name, kind, where. Filled from search_firms, get_firm, get_deal. \"funds\": Private funds, one a row: name, type, adviser, gross asset value and its date. Filled from get_firm, list_funds. \"companies\": Portfolio companies, one a row: name, sector, status, since when, owner. Filled from get_firm, list_companies. \"people\": People, one a row: name, title, firm, state, and their contact details where the lookup opened them. Filled from search_people, get_firm. \"parties\": The firms on one deal: each one's part, and its name. Filled from get_deal."New value: +"The house table to use: its columns, their order and their formats are the system's, so you give only `from` and never `columns`. Use one whenever the rows are of its kind. \"deals\": Deals, one a row: company, date, type, sector, the firms on each side, the value. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firm_deals\": One firm's deals, with the part the firm played on each. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"buyers\": A buyer list: one row a firm that bought, with how many deals, the latest, and what it bought. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"advisers\": Sellers' advisers: one row a bank, with how many sales it advised, the latest, and the companies sold. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"deals_by_year\": Deal activity: one row a year, with the deals in it and how many state a value. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firms\": Firms, one a row: name, kind, where. Filled from search_firms, get_firm, get_deal. \"funds\": Private funds, one a row: name, type, adviser, gross asset value and its date. Filled from get_firm, list_funds. \"companies\": Portfolio companies, one a row: name, sector, status, since when, owner. Filled from get_firm, list_companies. \"found_companies\": Companies found by sector and size, one a row: name, place, NAICS code and industry, staff, founded, PPP loan, the owner or officer named. Filled from find_companies. \"people\": People, one a row: name, title, firm, state, and their contact details where the lookup opened them. Filled from search_people, get_firm. \"parties\": The firms on one deal: each one's part, and its name. Filled from get_deal."
    • changedInput schema / properties / sheets / items / properties / table / enum
      Previous value: -[
      -  "deals",
      -  "firm_deals",
      -  "buyers",
      -  "advisers",
      -  "deals_by_year",
      -  "firms",
      -  "funds",
      -  "companies",
      -  "people",
      -  "parties"
      -]New value: +[
      +  "deals",
      +  "firm_deals",
      +  "buyers",
      +  "advisers",
      +  "deals_by_year",
      +  "firms",
      +  "funds",
      +  "companies",
      +  "found_companies",
      +  "people",
      +  "parties"
      +]
    • changedInput schema / properties / slides / items / properties / table / properties / table / description
      Previous value: -"The house table to use: its columns, their order and their formats are the system's, so you give only `from` and never `columns`. Use one whenever the rows are of its kind. \"deals\": Deals, one a row: company, date, type, sector, the firms on each side, the value. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firm_deals\": One firm's deals, with the part the firm played on each. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"buyers\": A buyer list: one row a firm that bought, with how many deals, the latest, and what it bought. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"advisers\": Sellers' advisers: one row a bank, with how many sales it advised, the latest, and the companies sold. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"deals_by_year\": Deal activity: one row a year, with the deals in it and how many state a value. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firms\": Firms, one a row: name, kind, where. Filled from search_firms, get_firm, get_deal. \"funds\": Private funds, one a row: name, type, adviser, gross asset value and its date. Filled from get_firm, list_funds. \"companies\": Portfolio companies, one a row: name, sector, status, since when, owner. Filled from get_firm, list_companies. \"people\": People, one a row: name, title, firm, state, and their contact details where the lookup opened them. Filled from search_people, get_firm. \"parties\": The firms on one deal: each one's part, and its name. Filled from get_deal."New value: +"The house table to use: its columns, their order and their formats are the system's, so you give only `from` and never `columns`. Use one whenever the rows are of its kind. \"deals\": Deals, one a row: company, date, type, sector, the firms on each side, the value. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firm_deals\": One firm's deals, with the part the firm played on each. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"buyers\": A buyer list: one row a firm that bought, with how many deals, the latest, and what it bought. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"advisers\": Sellers' advisers: one row a bank, with how many sales it advised, the latest, and the companies sold. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"deals_by_year\": Deal activity: one row a year, with the deals in it and how many state a value. In a document and on a slide it is drawn as a chart as well. Filled from search_deals, list_deals, deals_for_company, get_firm, get_deal. \"firms\": Firms, one a row: name, kind, where. Filled from search_firms, get_firm, get_deal. \"funds\": Private funds, one a row: name, type, adviser, gross asset value and its date. Filled from get_firm, list_funds. \"companies\": Portfolio companies, one a row: name, sector, status, since when, owner. Filled from get_firm, list_companies. \"found_companies\": Companies found by sector and size, one a row: name, place, NAICS code and industry, staff, founded, PPP loan, the owner or officer named. Filled from find_companies. \"people\": People, one a row: name, title, firm, state, and their contact details where the lookup opened them. Filled from search_people, get_firm. \"parties\": The firms on one deal: each one's part, and its name. Filled from get_deal."
    • changedInput schema / properties / slides / items / properties / table / properties / table / enum
      Previous value: -[
      -  "deals",
      -  "firm_deals",
      -  "buyers",
      -  "advisers",
      -  "deals_by_year",
      -  "firms",
      -  "funds",
      -  "companies",
      -  "people",
      -  "parties"
      -]New value: +[
      +  "deals",
      +  "firm_deals",
      +  "buyers",
      +  "advisers",
      +  "deals_by_year",
      +  "firms",
      +  "funds",
      +  "companies",
      +  "found_companies",
      +  "people",
      +  "parties"
      +]
  5. Added

TDQS

A4.4/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Beyond the annotations (readOnlyHint=false, destructiveHint=false), it discloses that the file is validated before being kept and that errors are reported once with what to fix, plus that `replaces` overwrites the whole content as a new version. That validation-and-replace behavior is genuinely non-obvious and useful. It doesn't cover permission needs, size/time limits, or the returned handle, so not a 5.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

It is front-loaded with the purpose and organized logically: purpose, then recipe/table/columns decision, then the pattern language, then replaces. It is a dense, long paragraph where the pattern enumeration could be list-formatted, but nearly every clause carries actionable information.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness4/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a complex 8-parameter nested-schema tool with no output schema, the description covers the recipe shapes, house tables, filling mechanism, and validation behavior adequately. It stops short of describing the return value (artifact id/link) or any limits, but the schema and annotations carry most of the remaining weight.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters5/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Though schema coverage is 100%, the description adds substantial meaning beyond the schema: it spells out the full row-pattern grammar ({company}, {parties[role=Buyer].name}, {date|year}, {parties|count}, link syntax) and explains that `from` runs a lookup server-side filling every page. This tells an agent how to compose values in a way the schema properties alone don't fully convey.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The first sentence states a specific verb and resource: 'Makes a file the person keeps: an Excel workbook, a Word document or a PowerPoint deck,' and clarifies where it lives ('their artifacts, where they open and download it'). An agent immediately knows this is the artifact-creation tool rather than a read tool like get_artifact or list_artifacts.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

It gives clear triggering conditions ('when they ask for a file, a spreadsheet, a memo, a deck') and internal routing rules: use `recipe` for house shapes, use a house `table` with `from` for record tables, and `columns` only when no house table fits. It does not explicitly contrast with siblings like preview_table or style_artifact, so an agent must infer when to preview or restyle rather than make.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Try in Browser

Glama MCP Gateway

Add one secure layer between your agents and this server.

Resources