Notion Database

script

/* ----- database id: paste ID between "quotes" -----*/
const dbid = ""; // from db page link,

// endpoint url
const endpoint = "https://api.notion.com/v1/pages";

//get draft title + content, remove blank lines
const lines = draft.content.replace(/$\s*\n+/gm, "\n").trim().split('\n'); 

const title = lines.shift().replace(/^# /, "");

// create page
const parent = { "database_id": dbid };

//"Name" refers to the title property of your db pages, default is "Name", if you have changed this, replace "Name" below
const properties = { 
					"title": [ {"text": { "content": title}}] ,				
					};

const children = [];

const page = { parent, properties, children };	 

//-----------------

function addBlock(line){

	const block =	{"object": "block", "type" : "paragraph"};
	const anyPref = /^(\s*([-*+]|#+)\s+)/;

	// map prefix to block type
	const types = new Map ([  
					["to_do", /^(\s*[-*+]\s\[\s]\s+)/],
					["bulleted_list_item", /^(\s*[-*+]\s+)/],
					["heading_3", /^(\s*###\s+)/],	
					["heading_2", /^(\s*##\s+)/],
					["heading_1", /^(\s*#\s+)/],  
	]);

	// if any prefix
	if (anyPref.test(line)) {

		// get type
		types.forEach( ( reg, name ) => {
						if (reg.test(line)) {
							block.type = name;
							line = line.replace(reg, ""); 
						}})
	}
	// complete block
	block[block.type] = {"rich_text": [{ "type": "text", 
									"text": { "content" : line }}]};

	children.push(block);
	}

// ---------------------

//if lines, add child blocks
if (lines) {
	
	lines.forEach(addBlock);

}	

// create Notion instance to make request
let notion = Notion.create();
let response = notion.request({
	"url": endpoint,
	"method": "POST",
	"data": page 
	});

// result 
if (!response.statusCode == 200) {

	alert(`Notion Error: ${response.statusCode}
	
${notion.lastError}`);
	context.fail();
}
if (response.statusCode == 200) {
    console.log('Successfully inserted into Notion database');
  } else {
    alert(`Notion Error: ${response.statusCode} ${notion.lastError}`);
    console.log('Failed to insert into Notion database');
    console.log(response.statusCode + ': ' + response.error);
  }