Logic App to use a List or a Page from Notion to create a custom string based on a list
Hassles
-
conversion of types
-
resolve the null errors while moving them to the list
-
debugger
-
Script creator
Query timeline
Sample Object in jsonlint
{
"object": "page",
"id": "df7f9618-35b2-4775-884c-5a574615a3ea",
"created_time": "2023-09-13T06:43:00.000Z",
"last_edited_time": "2023-09-13T06:44:00.000Z",
"created_by": {
"object": "user",
"id": "fba5280d-232d-4886-861b-90379dc39e1e"
},
"last_edited_by": {
"object": "user",
"id": "fba5280d-232d-4886-861b-90379dc39e1e"
},
"cover": null,
"icon": null,
"parent": {
"type": "database_id",
"database_id": "ed1d3bf6-6d04-4314-a7fd-f71f6418f79b"
},
"archived": false,
"properties": {
"Category": {
"id": "%3E%40rm",
"type": "multi_select",
"multi_select": [
{
"id": "4f6623af-09ab-455d-92c6-74eb501cc110",
**"name": "DevOps",**
"color": "purple"
}
]
},
"Courseware": {
"id": "FDwp",
"type": "checkbox",
"checkbox": true
},
"PromoVideo": {
"id": "KuqE",
"type": "url",
"url": "https://www.linkedin.com/feed/update/urn:li:activity:7106966756090368000/"
},
"Self Rating": {
"id": "QmK%5D",
"type": "number",
"number": 9
},
"Experience Hands-on": {
"id": "Sqql",
"type": "rich_text",
"rich_text": [
{
"type": "text",
"text": {
"content": "10",
"link": null
},
"annotations": {
"bold": false,
"italic": false,
"strikethrough": false,
"underline": false,
"code": false,
"color": "default"
},
"plain_text": "10",
"href": null
}
]
},
"Years": {
"id": "Xjmt",
"type": "number",
"number": 10
},
"Last edited time": {
"id": "c%3Ab%3D",
"type": "last_edited_time",
"last_edited_time": "2023-09-13T06:44:00.000Z"
},
"**Technology**": {
"id": "title",
"type": "title",
"title": [
{
"type": "text",
"text": {
"**content**": "**Communication**",
"link": null
},
"annotations": {
"bold": false,
"italic": false,
"strikethrough": false,
"underline": false,
"code": false,
"color": "default"
},
"plain_text": "Communication",
"href": null
}
]
}
},
"url": "https://www.notion.so/Communication-df7f961835b24775884c5a574615a3ea",
"public_url": "https://pexabo.notion.site/Communication-df7f961835b24775884c5a574615a3ea"
}
https://jsonlint.com/
To get the name property use the parse json
Null values is creating issues
Null fixer
https://adatis.co.uk/parsing-json-with-null-able-properties-in-logic-apps
fixers
Added
["string","null"]
move the code to type
Did not fix it and now maybe fix the matrix
Append properly find the correct node
Hr needs everything ready on the email and the contracts are turning out fast
Coming there
More attachments needed > theory of constrains > different than cover letter
Similar business requests
References
https://developers.notion.com/docs/authorization
https://stackoverflow.com/questions/55211673/azure-logic-app-http-post-in-for-each-loop-shows-unauthorized-error
https://www.notion.so/pexabo/ed1d3bf66d044314a7fdf71f6418f79b?v=fab3e53ca97d41cda83764024df4fb50
Imported from rifaterdemsahin.com · 2023