Skip to content
Forums
Forums
Features
HackerNews>callin.i...
 
Notifications
Clear all

HackerNews>callin.io integration

 
Features
Last Post by jan 5 years ago
6 Posts
2 Users
0 Reactions
3 Views
RSS
Rohan_Ahmed
 Rohan_Ahmed
(@rohan_ahmed)
Posts: 3
Active Member
Topic starter
 

Hello! I'm attempting to add Hacker News articles to my Airtable base.

The Hacker News node is producing tables with outputs. However, when I connect my Airtable base, it's not functioning correctly, resulting in approximately 100 new blank entries being added to the base.

I've enabled the “Add all fields” option in my Airtable node. I'm encountering the following error message and am unsure how to prepare (create columns and name them) the Airtable base before starting the append process. Any assistance would be greatly appreciated.

ERROR: Airtable error response [UNKNOWNFIELDNAME]: Unknown field name: “created_at”

Error: Airtable error response [UNKNOWN_FIELD_NAME]: Unknown field name: "created_at"
    at Object.apiRequest (C:UsersRohan AhmedAppDataRoamingnpmnode_modulescallin.ionode_modulescallin.io-nodes-basedistnodesAirtableGenericFunctions.js:28:23)
    at processTicksAndRejections (internal/process/task_queues.js:97:5)

Could someone please guide me on how to set up the Airtable base with the necessary columns before appending data?

 
Posted : 22/09/2020 6:35 pm
jan
 jan
(@jan)
Posts: 39
Eminent Member
 

Hello and welcome to the community!

When you enable the "Add all fields" option, it's crucial to ensure that every field sent to the Airtable node is present in the target table. In your situation, it seems the "created_at" field is missing, and potentially others as well. You have two options: either verify that all necessary fields exist in your Airtable table, or disable the "Add all fields" setting and manually select only the fields you intend to add.

You can also refer to the documentation for examples:

 
Posted : 22/09/2020 7:01 pm
Rohan_Ahmed
 Rohan_Ahmed
(@rohan_ahmed)
Posts: 3
Active Member
Topic starter
 

Thank you very much. I've adjusted the "add all fields" setting to include only a single field, specifically selecting the "author" field using the following steps.

image

image1080×692 26.6 KB

I have since updated my Airtable by placing the Author field in the first column. However, I am still encountering the issue of 100 blank cells being added to my Airtable, though there are no error messages this time.

Any assistance would be greatly appreciated.

 
Posted : 22/09/2020 11:00 pm
jan
 jan
(@jan)
Posts: 39
Eminent Member
 

It should not be the value, it should be the names. So you would not set an expression, you would just set author.

 
Posted : 23/09/2020 5:45 am
Rohan_Ahmed
 Rohan_Ahmed
(@rohan_ahmed)
Posts: 3
Active Member
Topic starter
 

Great, it's functioning now!

I have a couple of quick questions:

  1. The Hacker News node's 'story url' field isn't capturing the page link. For instance, with a link like A Message to Our Customers | Hacker News for the story title "A Message to Our Customers", the 'story url' field is returning null. (Never mind, I've resolved this by using an encoded URL formula in Airtable.)
    image

    image1090×595 29.6 KB

  2. The Hacker News search results are currently filtered by points in descending order. How can I adjust this to filter by a date range, for example, retrieving all posts from January 2019 to January 2020?

Thanks a lot!

 
Posted : 23/09/2020 6:26 pm
jan
 jan
(@jan)
Posts: 39
Eminent Member
 

Glad to hear it's working and that you're enjoying callin.io!

Regarding your second question, that's unfortunately not possible at the moment as the functionality hasn't been implemented yet. Could you please submit a feature request for it? We can then review it. Thanks!

 
Posted : 23/09/2020 8:43 pm
Forum Jump:
Next Topic  
Share: