# iCalender File adds rows with dates

**URL:** <https://community.glideapps.com/t/icalender-file-adds-rows-with-dates/67293>\
**Category:** Ask for Help\
**Created:** [October 25, 2023, 6:39pm UTC](https://community.glideapps.com/t/icalender-file-adds-rows-with-dates/67293 "2023-10-25T18:39:12Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Brandon](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/brandon/32/58098_2.png) [@Brandon](https://community.glideapps.com/u/Brandon)\
**Post date:** [October 25, 2023, 6:39pm UTC](https://community.glideapps.com/t/icalender-file-adds-rows-with-dates/67293/1 "2023-10-25T18:39:12Z")

</div>

Most all calendars can spit out an iCalender file which has data for dates of things like AirBnB bookings:

Example link: [https://www.airbnb.com/calendar/ical/834061064644861837.ics?s=4da8c0d227932f0fb26142b3a127cb07](https://www.airbnb.com/calendar/ical/834061064644861837.ics?s=4da8c0d227932f0fb26142b3a127cb07)

How do I get the data from this file and Add Rows for each new calendar event?

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [October 26, 2023, 7:55am UTC](https://community.glideapps.com/t/icalender-file-adds-rows-with-dates/67293/2 "2023-10-26T07:55:44Z")

</div>

But how would you get the link from Airbnb in the first place? How do you integrate Airbnb into your app?

---

<div class="post-metadata">

**Author:** ![Brandon](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/brandon/32/58098_2.png) [@Brandon](https://community.glideapps.com/u/Brandon)\
**Post date:** [October 26, 2023, 2:51pm UTC](https://community.glideapps.com/t/icalender-file-adds-rows-with-dates/67293/3 "2023-10-26T14:51:25Z")

</div>

Hi @ThinhDinh

It is not necessarily about integrating Airbnb solely it is about integrating the iCal link data. Airbnb is the example of a use case.

Airbnb & VRBO both give you pre build links in your account and you can place link in:

1. Your calander (gmail/outlook)
2. Other app that accept iCal links

From a business operations perspective:  
Step1: upload your Airbnb Ical link  
Step2: Hit submit and new rows are added based on iCal events  
Step3:view updated Glide calendar

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [October 27, 2023, 1:07am UTC](https://community.glideapps.com/t/icalender-file-adds-rows-with-dates/67293/4 "2023-10-27T01:07:23Z")

</div>

I think it can work like this.

Step 1: User upload the ical file.

Step 2: You do an API call to the uploaded URL to get something like this.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/7/972a263e620fe8485697bb949834e9d2d99731bd.jpeg)

Step 3: Use AI to convert that to JSON.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/e/6e9be33bbd8e8c138df907157f35039454734bb3.png)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/b/fbdb92c10af1b19fb8e48c35fc7c5ff98230127f.jpeg)

Step 4: Use Query JSON to parse out the fields you need.

Step 5: Craft an API body to get ready for the Call API action to add multiple rows.

Step 6: Add the Call API action.

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [November 3, 2023, 1:07am UTC](https://community.glideapps.com/t/icalender-file-adds-rows-with-dates/67293/5 "2023-11-03T01:07:28Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.