Notion API - getting data from a database

Support
1

Hello MINDSTUDIO Community!
I am so happy to be part of it!

It is my first post here, so apologize if I would miss some info. Please, be patient for newbie mistakes :wink:

Below is the description of problem:

Context:

I am building RFP (request for price) Agent - for my client. The process is that - there are Googel sheet files with prices created on monthly basis in Google sheets.

Agent #1: read the files, and populate (or update) the prices for several manufacturers in Notion Database.

Agent #2: every time an email comes into mailbox with a new RFP request - it converts to the new request item which has standrdised layout. - just a spreadsheet for now.

Agent #3: for every new RFP - it seraches good items codes (in the spreadsheet from Agent #2) and goes to Notion Database with all the prices - and gets the price for each item.

Agent #4: Once all the prices are populated for certain RFP - it replies to the email of the same sender with Offer, and marks as “replied” in tracker.

….. and so on - there is much more actions in the process, probably 3-5 more other agents.

PROBLEM STATEMENT:

For Agent #3 - I have difficulty to search the database through Notion connector called “Query Notion Database”, as input - I provide the good item code. Below is the errors message from the debugger:

image
image372×559 44.8 KB

Any idea, what am I doing wrong?

2

Here is the Query Options - Filter:

{
  "filter": {
    "property": "Nr katalogowy (jako tekst)",
    "rich_text": {
      "equals": "{{code}}"
    }
  }
}
3

Hi @Ramesko88,

Thanks for the post!

Please allow us some time to look into this. I’ll get back to you as soon as I have an update.