What does the heart emoji sent by user U05A7KLNALC mean?

Help
1

This topic was automatically generated from Slack. You can find the original thread here.

:heart:

2

Thank you for the heart! If you have any questions about Pipedream, feel free to ask, and I’ll be happy to help.

3

tysm - i tagged you in my query above

4

I apologize, but I cannot see any previous query you mentioned. Could you please provide the details of your question again? I’ll be happy to help you with any Pipedream-related questions or issues.

5

i’m setting up a workflow from google sheets > notion database, using “Create Page from Database from Notion API”

I was able to successfully test, but I’m encountering two errors: (edited)
[6:28 PM] APIResponseError
body failed validation: body.properties.Date & Time.date.start should be a valid ISO 8601 date string, instead was "08/10/2023 7:00:00 pm".

6

i’ve tried adding in the format_iso8601_datetime helper but that does not resolve this issue.

7

see above

8

I see that you’re having an issue with the date format when using the “Create Page from Database from Notion API” action. The error message indicates that the date format should be in ISO 8601 format, but you’re providing "08/10/2023 7:00:00 pm". To resolve this issue, you can use the format_iso8601_datetime helper function to convert the date string into the required ISO 8601 format. Here’s an example of how to use the helper function: const dateStr = "08/10/2023 7:00:00 pm"; const isoDate = format_iso8601_datetime(dateStr); After converting the date string to ISO 8601 format, you can pass the isoDate variable to the Notion API action. If you’ve already tried this and it’s still not working, please provide more details about your workflow and the steps you’ve taken, so I can better assist you.

9

thank you i do believe i have followed the workflow you’ve recommended, but I still encounter this error

10

here are the full details of the error

11

I apologize for the inconvenience. To better understand the issue, could you please provide more details about your workflow, such as the specific steps you’re using, and the code you’ve implemented for the format_iso8601_datetime helper function? This will help me identify the problem and provide a more accurate solution.

12 
at null.buildRequestError (/tmp/__pdg__/dist/code/2d7f24927952ae4e4693725f3118b0f2af9de72c71af477fdaefcf0b4f4f46c7/node_modules/.pnpm/@notionhq+client@2.2.9/node_modules/@notionhq/client/build/src/errors.js:162:16)
    at Client.request (/tmp/__pdg__/dist/code/2d7f24927952ae4e4693725f3118b0f2af9de72c71af477fdaefcf0b4f4f46c7/node_modules/.pnpm/@notionhq+client@2.2.9/node_modules/@notionhq/client/build/src/Client.js:347:54)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at Object.run (file:///tmp/__pdg__/dist/code/2d7f24927952ae4e4693725f3118b0f2af9de72c71af477fdaefcf0b4f4f46c7/code/actions/create-page-from-database/create-page-from-database.mjs:74:22)
    at null.executeComponent (/var/task/launch_worker.js:229:22)
    at MessagePort.messageHandler (/var/task/launch_worker.js:726:28)
13

hi any help would be greatly appreciated!

14

I apologize for the delay in my response. I understand you’re facing an issue with the date format when using the “Create Page from Database from Notion API” action. To help you further, I would need more information about your workflow, such as the specific steps you’re using, and the code you’ve implemented for the format_iso8601_datetime helper function. Please provide these details so I can better assist you in resolving the issue.

15

thank you !

16

here is the info

17

You’re welcome! If you have any more questions or need further assistance with Pipedream, feel free to ask. I’m here to help!

18

first is a trigger from google sheets

19

New Row Added (Instant) from Google Sheets

20

followed by format_iso8601_datetime