I am trying to create an auto social media content poster.
It fetches from Notion database using watch Database/Page (working fine in make.com)
Throws to Notion Search Objects with a filter to pull posts labelled as Scheduled and sort by Date Created, Asc order (working fine as well)
A router to pass the post to FB, LI, X etc
The FB Pages module keeps giving the error below. However, when I try mapping correct field items, I can see the preview of values being passed to the FB module from Router, but at run time, I get the error below.
DataError
The post is empty. Please enter a message to share. (197, OAuthException)
Origin
Facebook Pages
I fetch values using either of the below methods, none work.
{{9.properties_value.Final Caption[0].plain_text}}
{{9.properties_value.Final Caption[0].text.content}}
The Final Caption field keeps the final, publishable version of the post to publish on FB.
It’s hard to tell without screenshots of the initial steps or input bundles but one recommendation I can make for testing is to use the “Set Variable” module and see if
{{9.properties_value.Final Caption [0].plain_text}}
{{9.properties_value.Final Caption [0].text.content}}
produces any output. This speeds up the time it takes for me to tinker and get the output I’m looking for. It might be an issue with the datapill you’ve selected or the index you’ve specified or lack thereof.
Followed your suggestion, adding a Set variable module (btw, I tried adding this before and got the same results as explained below… once before the router, 2nd time after the router and before FB module…
@wxm1, are you running these steps individually? If so, the datapills won’t contain any values. To accurately test, you’ll need to click “Run Once” on the bottom of your screen.
Great to hear you figured it out! The 0, 1, 3 is considered an index and you usually use it to identify a certain item in an array. 0 represents the first item, 1 the second, 2 the third and so on…You can identify which fields are considered an array when you see them end with square brackets
I was a little surprised that “Final Caption” was considered an array. I’m sure there’s only one final caption per Notion post. An example of when you’d use an array is if you made an API request to get Company Employees, they might be delivered in an array or line items on an invoice.