Using a webhook to get a Notion page body

Hi @blueprintbrian!

A couple of thoughts / questions:

1. I believe doing what you’re trying to achieve is going to be very difficult using the Webhooks by Zapier app and would opt for using code instead, as it’s going to require looping through each of the block children (you correctly identified that that is what you need to get the content) and manipulating each one - theoretically, this could be done with Looping by Zapier, but I expect it would be pretty painful.
2. Do you need to make updates to the same page every time or will this Zap be dynamic and make changes to many different pages throughout your Notion account?
3. Can you please share a screenshot of the error(s) you’re getting when you run this webhook? OR copy/paste the error message so we can know what the system says is wrong?

Yah, definitely possible with a code step. Below is the code I used to perform the action in this brief video. Difficult to advise on more specifics for you without screenshots or recordings of your data, how you’d like to manipulate it, and where you want it to go.

output = {};

let results = [];

const appKey = ""; // ADD YOUR OWN NOTION INTEGRATION SECRET KEY BETWEEN THE QUOTES
const pageId = ""; // ADD YOUR OWN ORIGINATING PAGE ID BETWEEN THE QUOTES
let appData = "";

try {
  const appResp = await fetch(
    `https://api.notion.com/v1/blocks/${pageId}/children`, {
      method: 'GET',
      headers: {
        'Notion-Version': '2022-06-28',
        'Authorization': 'Bearer ' + appKey
      }
    }
  );

  appData = await appResp.text();
  appData = JSON.parse(appData);
  results = appData.results;
} catch (e) {
  console.log(e.message);
}

for (let i = 0; i < results.length; i++) {
  const type = results[i].type;
  results[i][type].rich_text[0].text.content = results[i][type].rich_text[0].text.content.replace(/\bbody\b/g, "lollapalooza");
  results[i][type].rich_text[0].plain_text = results[i][type].rich_text[0].text.content;
}

try {
  const appResp = await fetch(
    `https://api.notion.com/v1/blocks/${pageId}/children`, {
      method: 'PATCH',
      headers: {
        'Content-Type': 'application/json',
        'Notion-Version': '2022-06-28',
        'Authorization': 'Bearer ' + appKey
      },
      body: JSON.stringify({
        'children': results
      })
    }
  );

  appData = await appResp.text();
  appData = JSON.parse(appData);
} catch (e) {
  console.log(e.message);
}

Yes, the code is Javascript :)

I would define the input data as pageId (without the curly braces and keeping the d lowercase).

Then in the code, you’ll replace the quotes for the page ID with inputData.pageId, so the full line is:

const pageId = inputData.pageId;

Note that there are no longer any quotes.

Also note that for your purposes, since you are just copy/pasting the body from one place to another, you will likely not need the for loop (the block of code seen below):

for (let i = 0; i < results.length; i++) {
  const type = results[i].type;
  results[i][type].rich_text[0].text.content = results[i][type].rich_text[0].text.content.replace(/\bbody\b/g, "lollapalooza");
  results[i][type].rich_text[0].plain_text = results[i][type].rich_text[0].text.content;
}

Also, in the last section of code, you’ll want to replace ${pageId} with the actual ID of the page you’re copying to, as seen below. If you leave ${pageId}, you’ll just be appending it to the original page, as you saw in my demo video. If the page you’re copying to is the same every time this operation happens, that’s easy. If it’s dynamic, you’ll want to define another variable like secondPageId and add it with the dollar sign and curly braces in that block of code (ie. ${secondPageId}).

try {
  const appResp = await fetch(
    `https://api.notion.com/v1/blocks/id-of-page-you-are-copying-to/children`, {

Oh! In that case, you’d want to do something like this (following the first try/catch block):

output.results = "";

for (let i = 0; i < results.length; i++) {
  const type = results[i].type;
  if (results[i][type].rich_text.length > 0) {
    output.results += `${results[i][type].rich_text[0].plain_text}\n`;
  }
}

And then yes, you are correct that you could eliminate the second try/catch block :)

Can you add the following line of code just before output.results = “”; ?

output.appData = appData;

And then take screenshots of what appears under “App Data” in your test results. Note that it will include data from your document, so if there is any personally identifiable or sensitive information, please be sure to redact it before posting.

Ah. Okay, so Notion has a slightly inconvenient feature when it comes to automation via code. You actually need to manually share a page with the integration. Here’s a video walking you through this (along with a workaround so that you don’t need to do this manual process for every page in your database): https://www.loom.com/share/cbd0922733b04bf2b34d2e114c8e5697?sid=5b88b76a-0ac7-4287-bfcf-0ccc5655407a