<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>Forem: Mohd Danish</title>
    <description>The latest articles on Forem by Mohd Danish (@mddanishyusuf).</description>
    <link>https://forem.com/mddanishyusuf</link>
    <image>
      <url>https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F145496%2F44ca14db-847a-4f86-94de-ed240c1bccdd.png</url>
      <title>Forem: Mohd Danish</title>
      <link>https://forem.com/mddanishyusuf</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://forem.com/feed/mddanishyusuf"/>
    <language>en</language>
    <item>
      <title>Free Notion Style Avatar Generator</title>
      <dc:creator>Mohd Danish</dc:creator>
      <pubDate>Mon, 03 Jun 2024 17:13:14 +0000</pubDate>
      <link>https://forem.com/mddanishyusuf/free-notion-style-avatar-generator-2a4l</link>
      <guid>https://forem.com/mddanishyusuf/free-notion-style-avatar-generator-2a4l</guid>
      <description>&lt;p&gt;I built a free tool this weekend for Notion lovers&lt;a href="https://iconbuddy.com/notion-style-avatar-generator" rel="noopener noreferrer"&gt;(Notion Avatar)&lt;/a&gt;.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://iconbuddy.com/notion-style-avatar-generator" rel="noopener noreferrer"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F5b9bioino6h6v32t9t6l.png" alt="Image description" width="800" height="419"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;Notion style Avatar generator, A online Notion style avatar free generator tool to make profile with head, eyes, nose, eyes, glasses, hair, &amp;amp; head parts, also easily customize background color.&lt;/p&gt;

&lt;p&gt;Checkout here → &lt;a href="https://iconbuddy.com/notion-style-avatar-generator" rel="noopener noreferrer"&gt;https://iconbuddy.com/notion-style-avatar-generator&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;Let me know your feedback on this. Thanks&lt;/p&gt;

</description>
      <category>notion</category>
      <category>avatar</category>
    </item>
    <item>
      <title>Search Engine For 200k+ Open Source Icons</title>
      <dc:creator>Mohd Danish</dc:creator>
      <pubDate>Thu, 25 Apr 2024 06:11:00 +0000</pubDate>
      <link>https://forem.com/mddanishyusuf/search-engine-for-200k-open-source-icons-4mfc</link>
      <guid>https://forem.com/mddanishyusuf/search-engine-for-200k-open-source-icons-4mfc</guid>
      <description>&lt;p&gt;Ever spent ages searching for the perfect SVG icon online? As a designer myself, I know the struggle all too well. That's why &lt;strong&gt;eight months ago&lt;/strong&gt;, I decided to build a solution: &lt;strong&gt;&lt;a href="https://iconbuddy.com/" rel="noopener noreferrer"&gt;Iconbuddy&lt;/a&gt;&lt;/strong&gt;.&lt;/p&gt;

&lt;p&gt;→ &lt;a href="https://iconbuddy.com" rel="noopener noreferrer"&gt;https://iconbuddy.com/&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Iconbuddy&lt;/strong&gt; is a search engine I developed specifically to streamline your SVG icon hunt. We've &lt;strong&gt;indexed a massive collection of 226,377 open-source icons&lt;/strong&gt; spread across 70+ collections. This means you have access to a vast library of high-quality icons, all conveniently searchable in one place.&lt;/p&gt;

&lt;p&gt;We update our database with new icons every 30 days, keeping your design library fresh.&lt;/p&gt;

&lt;p&gt;Using Iconbuddy is simple. Just head over to Iconbuddy: &lt;a href="https://iconbuddy.com" rel="noopener noreferrer"&gt;https://iconbuddy.com&lt;/a&gt; and enter your search term. Powered by Algolia, allowing you to easily find the perfect one for your project.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F20m6ofh32q0dw2ireei7.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F20m6ofh32q0dw2ireei7.png" alt="Iconbuddy" width="800" height="573"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;Iconbuddy is more than just a search engine – We have more ways to use this engine.&lt;/p&gt;

&lt;h2&gt;
  
  
  Figma Plugin
&lt;/h2&gt;

&lt;p&gt;I also build Figma Plugin to directly browse icons in your Figma Projects. It's got 20,000 install in last 4 months.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://www.figma.com/community/plugin/1273969678979729204/iconbuddy" rel="noopener noreferrer"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F7dc7a4cgk46i2tb2o6sy.png" alt="Figma Plugin Iconbuddy" width="800" height="445"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;a href="https://www.figma.com/community/plugin/1273969678979729204/iconbuddy" rel="noopener noreferrer"&gt;Checkout Figma Plugin Here&lt;/a&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  VS Code Extension
&lt;/h2&gt;

&lt;p&gt;Last month, I also launched a plugin for your VS Code editor, allowing you to directly search and copy JSX and SVG code. It's already got over 300 installs within 30 days!&lt;/p&gt;

&lt;p&gt;&lt;a href="https://marketplace.visualstudio.com/items?itemName=mddanishyusuf.iconbuddy-vs-code-plugin" rel="noopener noreferrer"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Frhyeggh6hxcam7614opi.png" alt="VS Code Extension" width="800" height="487"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;a href="https://marketplace.visualstudio.com/items?itemName=mddanishyusuf.iconbuddy-vs-code-plugin" rel="noopener noreferrer"&gt;Install VS Code Extension in your Editor&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;So, next time you're on the hunt for the perfect SVG icon, ditch the endless web searches and head straight to Iconbuddy. We've got you covered!&lt;/p&gt;

</description>
      <category>design</category>
      <category>search</category>
      <category>opensource</category>
    </item>
    <item>
      <title>180k+ Open Source Free Icons</title>
      <dc:creator>Mohd Danish</dc:creator>
      <pubDate>Fri, 18 Aug 2023 06:28:25 +0000</pubDate>
      <link>https://forem.com/mddanishyusuf/180k-open-source-free-icons-2hfa</link>
      <guid>https://forem.com/mddanishyusuf/180k-open-source-free-icons-2hfa</guid>
      <description>&lt;p&gt;There are numerous Open Source Icon projects available on GitHub; however, they are not all managed in a single location.&lt;/p&gt;

&lt;p&gt;To address this issue, I have developed a project known as IconBuddy.app, which provides a centralized platform for browsing &lt;strong&gt;a collection of 180k+ icons&lt;/strong&gt;.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://iconbuddy.app" rel="noopener noreferrer"&gt;https://iconbuddy.app&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;a href="https://iconbuddy.app" rel="noopener noreferrer"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fhalkadvl9pf9p01r66ux.png" alt="Download, Customize, Edit and Personalize. Over 180k+ open source icons." width="800" height="418"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;Search icons across more than 150 collections.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://iconbuddy.app" rel="noopener noreferrer"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F6l80m2rfwz0i7njgxpzj.png" alt="Search icons" width="800" height="463"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;Customize icon with color, size, background color, gradient, &amp;amp; more.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://iconbuddy.app" rel="noopener noreferrer"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fnz2pqsw7q2y70dy5fsr0.png" alt="Customize icon" width="800" height="463"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;We have a wide range of formats to choose from, so you can download the icons in the format you want. We have SVG, PNG, WEBP, JSX, VUE and BASE64, URLs, CSS background snippers, HTML Image tags. We have it all.&lt;/p&gt;

&lt;p&gt;Go and checkout here → &lt;a href="https://iconbuddy.app" rel="noopener noreferrer"&gt;https://iconbuddy.app&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;Looking forward to know your feedbacks. Thanks&lt;/p&gt;

</description>
      <category>design</category>
      <category>icon</category>
    </item>
    <item>
      <title>5 simple Backend Tools for your website</title>
      <dc:creator>Mohd Danish</dc:creator>
      <pubDate>Sat, 10 Jun 2023 17:55:29 +0000</pubDate>
      <link>https://forem.com/mddanishyusuf/5-simple-backend-tools-for-your-website-oco</link>
      <guid>https://forem.com/mddanishyusuf/5-simple-backend-tools-for-your-website-oco</guid>
      <description>&lt;p&gt;Are you looking for simple and efficient backend tools to power your website? In this article, we will introduce you to five top-notch backend tools that can help you streamline your development process and enhance the functionality of your website. Whether you are a beginner or an experienced developer, these tools offer user-friendly interfaces and robust features to meet your backend needs.&lt;/p&gt;

&lt;p&gt;Let's dive into the list of these powerful backend tools:&lt;/p&gt;

&lt;h3&gt;
  
  
  1. Table Backend
&lt;/h3&gt;

&lt;p&gt;A simple and easy backend solution and database for small projects including Marketplaces, Job Boards, Roadmaps, Todo Tasks, and Other Use Cases. An alternaitve to Airtable, Google Sheet, Glid Apps, NoCodb, Baserow, Notion, Smartsheet, and more.&lt;/p&gt;

&lt;p&gt;Key Features:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Powerful canvas-based data grid for handling millions of rows.&lt;/li&gt;
&lt;li&gt;Unlock faster and more secure APIs with our cutting-edge caching technology.&lt;/li&gt;
&lt;li&gt;Secure API by restricting access to the project's designated domain.&lt;/li&gt;
&lt;li&gt;Index table data and enable seamless text search functionality via API.&lt;/li&gt;
&lt;li&gt;Boost asset loading speed with our CDN for efficient delivery of images.&lt;/li&gt;
&lt;li&gt;Powerful API integration for seamless data retrieval and manipulation.&lt;/li&gt;
&lt;li&gt;Automatic backups and data protection.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;→ &lt;a href="https://tablebackend.com/" rel="noopener noreferrer"&gt;Learn more about Table Backend&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fp6pgmfglg7fgebx2j707.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fp6pgmfglg7fgebx2j707.png" alt="Image description" width="800" height="442"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;With Table Backend you can make simple website and there are list of templates demo.&lt;/p&gt;

&lt;p&gt;→ &lt;a href="https://tablebackend.com/templates" rel="noopener noreferrer"&gt;https://tablebackend.com/templates&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Farui8gokloyw3ahb6wyw.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Farui8gokloyw3ahb6wyw.png" alt="Image description" width="800" height="442"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;h3&gt;
  
  
  2. Airtable
&lt;/h3&gt;

&lt;p&gt;Airtable is a popular backend tool that combines the flexibility of a spreadsheet with the power of a database. It enables you to organize and collaborate on your data seamlessly.&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Spreadsheet-like interface for easy data organization.&lt;/li&gt;
&lt;li&gt;Customizable fields and data types.&lt;/li&gt;
&lt;li&gt;Collaboration features for team projects.&lt;/li&gt;
&lt;li&gt;API integration for data synchronization with other apps.&lt;/li&gt;
&lt;li&gt;Rich text formatting and attachments.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;→ &lt;a href="https://airtable.com/" rel="noopener noreferrer"&gt;Learn more about Airtable&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fzm2ili6he14lh5uccvlv.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fzm2ili6he14lh5uccvlv.png" alt="Image description" width="800" height="442"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;h3&gt;
  
  
  3. back4app
&lt;/h3&gt;

&lt;p&gt;back4app is a scalable backend platform that simplifies the development of web and mobile applications. It offers a range of backend features and services to accelerate your development process.&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;GraphQL and REST APIs for data retrieval and manipulation.&lt;/li&gt;
&lt;li&gt;Real-time database updates with LiveQuery.&lt;/li&gt;
&lt;li&gt;User authentication and authorization.&lt;/li&gt;
&lt;li&gt;Cloud functions for custom server-side logic.&lt;/li&gt;
&lt;li&gt;File storage and push notifications.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;→ &lt;a href="https://www.back4app.com/" rel="noopener noreferrer"&gt;Learn more about back4app&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fnf9c4ol6w6m8st0vqlvi.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fnf9c4ol6w6m8st0vqlvi.png" alt="Image description" width="800" height="442"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;h3&gt;
  
  
  4. Firebase
&lt;/h3&gt;

&lt;p&gt;Firebase is a comprehensive backend platform provided by Google. It offers a wide range of tools and services to help you build and scale your web or mobile app.&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Real-time database for seamless data synchronization.&lt;/li&gt;
&lt;li&gt;User authentication and authorization.&lt;/li&gt;
&lt;li&gt;Cloud Firestore for scalable and flexible NoSQL data storage.&lt;/li&gt;
&lt;li&gt;Hosting for deploying and serving your app.&lt;/li&gt;
&lt;li&gt;Cloud Functions for serverless computing.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;→ &lt;a href="https://firebase.google.com/" rel="noopener noreferrer"&gt;Learn more about Firebase&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F9ivxruwc0rogq5idzal6.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F9ivxruwc0rogq5idzal6.png" alt="Image description" width="800" height="442"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;h3&gt;
  
  
  5. Supabase
&lt;/h3&gt;

&lt;p&gt;Supabase is an open-source alternative for building scalable backend applications. It combines the benefits of a database with the simplicity of a serverless platform.&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;PostgreSQL database with JSONB support.&lt;/li&gt;
&lt;li&gt;Real-time subscriptions for instant updates.&lt;/li&gt;
&lt;li&gt;Authentication and authorization.&lt;/li&gt;
&lt;li&gt;RESTful API generation.&lt;/li&gt;
&lt;li&gt;Custom functions with serverless architecture.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;→ &lt;a href="https://supabase.com/" rel="noopener noreferrer"&gt;Learn more about Supabase&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fgqwwsoym2grfrrv3xuuv.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fgqwwsoym2grfrrv3xuuv.png" alt="Image description" width="800" height="442"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;These five backend tools offer powerful features and intuitive interfaces to make your website development process smoother and more efficient. Choose the tool that best suits your project requirements and start building your website with ease.&lt;/p&gt;

&lt;p&gt;Happy coding!&lt;/p&gt;

</description>
      <category>backend</category>
      <category>api</category>
      <category>webdev</category>
    </item>
    <item>
      <title>Connect to APIs with NoCode</title>
      <dc:creator>Mohd Danish</dc:creator>
      <pubDate>Sat, 03 Jul 2021 16:28:48 +0000</pubDate>
      <link>https://forem.com/mddanishyusuf/connect-to-apis-with-nocode-40da</link>
      <guid>https://forem.com/mddanishyusuf/connect-to-apis-with-nocode-40da</guid>
      <description>&lt;p&gt;We all know that public APIs documentation is messy and don't know how to get started with any API. So, now you don't have to worry about complex documentations.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://nocodeapi.com" rel="noopener noreferrer"&gt;NoCodeAPI&lt;/a&gt;  makes it easy for you to connect with public APIs and give you a secure, simple, unique API endpoint with in-built features.&lt;/p&gt;

&lt;h3&gt;
  
  
  Benefits of using NoCodeAPI
&lt;/h3&gt;

&lt;ul&gt;
&lt;li&gt;⏲️ Bypass Limits&lt;/li&gt;
&lt;li&gt;👊 Hassle-Free&lt;/li&gt;
&lt;li&gt;🤯 No Server Headache&lt;/li&gt;
&lt;li&gt;⚡ Fast&lt;/li&gt;
&lt;li&gt;🔑 Secure&lt;/li&gt;
&lt;li&gt;✳️ Logs&lt;/li&gt;
&lt;li&gt;📜 Mini Documentation&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;This website has a huge list of applications like Google Sheet, Instagram, Youtube, Airtable, Zoho Mail, AWS S3, Vimeo, WordPress, Mailgun, Webflow, Spotify, Calendly, Twitter,  Telegram, Github, and more than 50 applications in its &lt;a href="https://nocodeapi.com/marketplace" rel="noopener noreferrer"&gt;marketplace&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;In this article, I'll show you how to connect with  &lt;a href="https://nocodeapi.com/google-sheets-api" rel="noopener noreferrer"&gt;Google sheet API&lt;/a&gt;,  &lt;a href="https://nocodeapi.com/airtable-api" rel="noopener noreferrer"&gt;Airtable API&lt;/a&gt;, &amp;amp;  &lt;a href="https://nocodeapi.com/webflow-cms-api" rel="noopener noreferrer"&gt;Webflow CMS API&lt;/a&gt; &lt;/p&gt;

&lt;p&gt;Before getting started first, create an account at  &lt;a href="https://app.nocodeapi.com/signup" rel="noopener noreferrer"&gt;NoCodeAPI&lt;/a&gt; and it just took 1-minute to start.&lt;/p&gt;

&lt;h2&gt;
  
  
  Connect with Google Sheet
&lt;/h2&gt;

&lt;p&gt;Login to NoCodeAPI, Go to the marketplace, find Google sheet API, &amp;amp; activate this.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fu5d99970yobgqx033cm8.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fu5d99970yobgqx033cm8.png" alt="Google Sheet Setup page" width="800" height="255"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;To make Google Sheet API you have to &lt;strong&gt;Authenticate with your Google Account&lt;/strong&gt;. After this, get your spreadsheet id to make Sheet API.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Sheet ID&lt;/strong&gt; - Your google spreadsheet ID of which you want API.&lt;/p&gt;

&lt;p&gt;Example URL &lt;strong&gt;&lt;a href="https://docs.google.com/spreadsheets/d/1i27K4e5m1H2-TTdXgVNmfzn_V2LolgjVtpGYjZ50NX4/edit" rel="noopener noreferrer"&gt;https://docs.google.com/spreadsheets/d/1i27K4e5m1H2-TTdXgVNmfzn_V2LolgjVtpGYjZ50NX4/edit&lt;/a&gt;&lt;/strong&gt;&lt;/p&gt;

&lt;p&gt;The &lt;strong&gt;Sheet ID&lt;/strong&gt; is the part after &lt;strong&gt;d/&lt;/strong&gt;, in the above link, it's &lt;strong&gt;1i27K4e5m1H2-TTdXgVNmfzn_V2LolgjVtpGYjZ50NX4&lt;/strong&gt;&lt;/p&gt;

&lt;p&gt;Click on the &lt;strong&gt;Create Google Sheet API&lt;/strong&gt; button then &lt;strong&gt;authenticate with your Google Account&lt;/strong&gt;. After authenticating you will be redirected back to the NoCodeAPI with a Modal, just follow the form and click on Create button.  🎉 Done!&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fyy72g5rzxsmgfc63z4rb.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fyy72g5rzxsmgfc63z4rb.png" alt="Google Sheet API endpoint" width="800" height="255"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;Now you can get your sheet tabs data as JSON with the endpoint showing in above picture. You can use an in-built playground to test the endpoint. Just click on &lt;strong&gt;Use this API&lt;/strong&gt;.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F4ii36guj223lamxfti2g.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F4ii36guj223lamxfti2g.png" alt="Google Sheet Playground" width="800" height="442"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;You can test this endpoint in your browser tab. &lt;a href="https://v1.nocodeapi.com/coder/google_sheets/moIDovKbPEuOexXh?tabId=data" rel="noopener noreferrer"&gt;https://v1.nocodeapi.com/coder/google_sheets/moIDovKbPEuOexXh?tabId=data&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;There are the following endpoints for Google Sheet API:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Get All Records - Get all sheet data by tabId.&lt;/li&gt;
&lt;li&gt;Get single row - Pass row id to get single row object from sheet.&lt;/li&gt;
&lt;li&gt;Append new row - Push new row into your google sheet.&lt;/li&gt;
&lt;li&gt;Update row - Pass an object with new values with row_id.&lt;/li&gt;
&lt;li&gt;Delete one row - You can also delete one row or multiple rows at a time.&lt;/li&gt;
&lt;li&gt;Create a new Spreadsheet - You can also make a fresh new spreadsheet with POST call.&lt;/li&gt;
&lt;li&gt;Add Sheet Tab - You can add a new tab into your spreadsheet with this endpoint.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;↳ &lt;a href="https://nocodeapi.com/docs/google-sheets-api" rel="noopener noreferrer"&gt;View google sheet API docs&lt;/a&gt; &lt;/p&gt;

&lt;h2&gt;
  
  
  Connect with Airtable
&lt;/h2&gt;

&lt;p&gt;Go to the marketplace, find Airtable API, &amp;amp; activate this.&lt;/p&gt;

&lt;p&gt;To make Airtable you need 2 values:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;API key&lt;/strong&gt; - You can get your Airtable API key from here ** &lt;a href="https://airtable.com/account" rel="noopener noreferrer"&gt;https://airtable.com/account&lt;/a&gt; **&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Base ID&lt;/strong&gt; - Go here **  &lt;a href="https://airtable.com/api" rel="noopener noreferrer"&gt;https://airtable.com/api&lt;/a&gt;  **  and select your form base then you can find the &lt;strong&gt;base ID&lt;/strong&gt; in URL &amp;amp; It begins with the &lt;strong&gt;app&lt;/strong&gt;. &lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Example: &lt;strong&gt;&lt;a href="https://airtable.com/appofMoPxdu7iQ7hf/api/docs" rel="noopener noreferrer"&gt;https://airtable.com/appofMoPxdu7iQ7hf/api/docs&lt;/a&gt;&lt;/strong&gt; -&amp;gt; &lt;strong&gt;appofMoPxdu7iQ7hf&lt;/strong&gt; is the &lt;strong&gt;Base ID&lt;/strong&gt;.&lt;/p&gt;

&lt;p&gt;Click on the &lt;strong&gt;Create Airtable API&lt;/strong&gt; button then put the required values into the form and click on the &lt;strong&gt;Create&lt;/strong&gt; button.  🎉 Done!&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fm66i7dx7ba17km54ty9y.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fm66i7dx7ba17km54ty9y.png" alt="Airtable API endpoint" width="800" height="251"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;There are the following endpoints for Airtable API:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Get All Records&lt;/strong&gt; - List all records from the table of your Airtable Base.&lt;/li&gt;
&lt;li&gt;*&lt;em&gt;Get Single Record *&lt;/em&gt;- Get a single record&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Create Records&lt;/strong&gt; - Create multiple new records into the table.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Update Records&lt;/strong&gt; - You can update multiple records in one API call.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Delete Records&lt;/strong&gt; - You can delete multiple records in one API call.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;&lt;a href="https://nocodeapi.com/docs/airtable-api" rel="noopener noreferrer"&gt;View Airtable API docs&lt;/a&gt; &lt;/p&gt;

&lt;h2&gt;
  
  
  Connect with Webflow CMS
&lt;/h2&gt;

&lt;p&gt;Webflow is the most powerful modern NoCode web builder on the internet. Webflow has its in-build database that is Webflow CMS. &lt;/p&gt;

&lt;p&gt;You can get your Webflow CMS data as JSON without any backend coding and server logic.&lt;/p&gt;

&lt;p&gt;Go to the marketplace, find Webflow API, &amp;amp; activate this.&lt;/p&gt;

&lt;p&gt;To make Webflow you need only one value:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;API Access key&lt;/strong&gt; - Go to &lt;strong&gt;dashboard&lt;/strong&gt; -&amp;gt; Click on &lt;strong&gt;three dots icon&lt;/strong&gt; -&amp;gt; &lt;strong&gt;Settings&lt;/strong&gt; -&amp;gt; &lt;strong&gt;Integrations&lt;/strong&gt; -&amp;gt; Generate &lt;strong&gt;API Access&lt;/strong&gt;.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Click on the &lt;strong&gt;Create Webflow API&lt;/strong&gt; button then put required values into the form and click on the &lt;strong&gt;Create&lt;/strong&gt; button.  🎉 Done!&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fv2x6u3luibzk4atpv8h5.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fv2x6u3luibzk4atpv8h5.png" alt="Webflow CMS API endpoint" width="800" height="251"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;There are the following endpoints for Webflow API:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Get All Collection Items&lt;/strong&gt; - Get your all items from the Webflow CMS collections.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Get Single Item&lt;/strong&gt; - Get a single Item of the CMS collection&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Add Item&lt;/strong&gt; - Add new item into the collection&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Update Records&lt;/strong&gt; - You can update item values into the collection.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Delete Item&lt;/strong&gt; - You can also delete an item from the collection.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;&lt;a href="https://nocodeapi.com/docs/webflow-cms-api" rel="noopener noreferrer"&gt;View Webflow CMS API docs&lt;/a&gt; &lt;/p&gt;

&lt;h2&gt;
  
  
  Conclusion
&lt;/h2&gt;

&lt;p&gt;This is all. I hope find this article useful and make your API development easy. Let me know your thought on the NoCodeAPI.&lt;/p&gt;

&lt;p&gt;↳ Website: &lt;a href="https://nocodeapi.com" rel="noopener noreferrer"&gt;https://nocodeapi.com&lt;/a&gt;&lt;br&gt;
↳ Follow me  &lt;a href="https://twitter.com/mddanishyusuf" rel="noopener noreferrer"&gt;@mddanishyusuf&lt;/a&gt; &lt;/p&gt;

&lt;p&gt;The last favor is from you that share this blog post on Facebook, Twitter, LinkedIn, or with your friends. 🙏&lt;/p&gt;

</description>
      <category>api</category>
      <category>nocode</category>
    </item>
    <item>
      <title>API Connector for data importing</title>
      <dc:creator>Mohd Danish</dc:creator>
      <pubDate>Sun, 28 Mar 2021 13:06:55 +0000</pubDate>
      <link>https://forem.com/mddanishyusuf/api-connector-for-data-importing-2dd6</link>
      <guid>https://forem.com/mddanishyusuf/api-connector-for-data-importing-2dd6</guid>
      <description>&lt;p&gt;If you have a lot of interesting data in your JSON format. Maybe in Airtable, or Webflow, or an API that you want to bring to Google Sheets. You can use NoCodeAPI to do just that. Crazy Awesome !! 😃&lt;/p&gt;

&lt;h3&gt;
  
  
  Video Tutorial
&lt;/h3&gt;

&lt;p&gt;If you love video tutorial then we also have video tutorial for you.&lt;br&gt;
&lt;iframe width="710" height="399" src="https://www.youtube.com/embed/eR_ZW4gUUn8"&gt;
&lt;/iframe&gt;
&lt;/p&gt;

&lt;h3&gt;
  
  
  Step 1 : Fetch JSON from a fake API
&lt;/h3&gt;

&lt;p&gt;⁃ For this tutorial we are going to fetch our fake JSON data from &lt;a href="https://jsonplaceholder.typicode.com/" rel="noopener noreferrer"&gt;JSON placeholder API&lt;/a&gt;&lt;br&gt;
⁃ As you scroll down, fake JSON placeholder offers different options to fetch this data. We are going to use &lt;a href="https://jsonplaceholder.typicode.com/todos" rel="noopener noreferrer"&gt;/todos&lt;/a&gt; to fetch 200 todos in JSON and create 200 rows in our google sheet.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Ftem7ykyidwls97dbavxb.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Ftem7ykyidwls97dbavxb.png" alt="fakeJSON-todos" width="800" height="522"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;⁃ Test if the endpoint is working by pasting this URL in your browser &amp;gt; &lt;code&gt;https://jsonplaceholder.typicode.com/todos&lt;/code&gt;. It should give you JSON data inside the browser (like below — I am using &lt;a href="https://chrome.google.com/webstore/detail/json-formatter/bcjindcccaagfpapjjmafapmmgkkhgoa?hl=en" rel="noopener noreferrer"&gt;JSON formatter&lt;/a&gt; chrome extension to beautify JSON).&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fvv1hryyonoqd28mw8c3e.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fvv1hryyonoqd28mw8c3e.png" alt="fakeJSON-test" width="800" height="1000"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;h3&gt;
  
  
  Step 2 : Connect Google Sheet with NoCodeAPI
&lt;/h3&gt;

&lt;p&gt;⁃ Sign In to NoCodeAPI dashboard by clicking &lt;a href="https://app.nocodeapi.com/login" rel="noopener noreferrer"&gt;here&lt;/a&gt;.&lt;br&gt;
⁃ Go to Marketplace and &lt;code&gt;Activate&lt;/code&gt; google sheet API&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fqsq7jp1z7txhyau2fnn2.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fqsq7jp1z7txhyau2fnn2.png" alt="Sheet Activate" width="800" height="468"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;⁃ Click on &lt;code&gt;Make Google Sheet&lt;/code&gt; API&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Ftkb31nowyab1vsddgei9.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Ftkb31nowyab1vsddgei9.png" alt="Sheet Make API" width="800" height="500"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;⁃ A sidebar appears. In the side bar, “Choose” your Google Account through which you are managing your Google Sheets.&lt;br&gt;
⁃ &lt;code&gt;Allow&lt;/code&gt; nocodeapi to manage your Google Sheets data&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Flwyiq2nwm7izoppaqdgi.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Flwyiq2nwm7izoppaqdgi.png" alt="Sheet API" width="800" height="1275"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;⁃ You will be redirected to NoCodeAPI dashboard.&lt;br&gt;
⁃ Give your API a name and paste your Sheet ID in the Sheet ID input field.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fh64taavxpbqupxkilhmi.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fh64taavxpbqupxkilhmi.png" alt="Sheet filled form" width="800" height="817"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;⁃ You can find you Google Sheet ID in your URL. It is located between &lt;code&gt;/d&lt;/code&gt; and &lt;code&gt;/edit&lt;/code&gt; text, like below.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fcjzof8a3as8zoix8e6wr.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fcjzof8a3as8zoix8e6wr.png" alt="Sheet ID" width="800" height="436"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;⁃ Click &lt;code&gt;Create&lt;/code&gt; button and it will generate your NoCodeAPI endpoint.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fsucuw1s2n3vfgxz8hqm5.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fsucuw1s2n3vfgxz8hqm5.png" alt="Sheet new endpoint" width="800" height="500"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;⁃ Using this endpoint we are going to import our JSON data to the Google Sheet.&lt;/p&gt;

&lt;h3&gt;
  
  
  Step 3 : Import your JSON data to Google Sheets
&lt;/h3&gt;

&lt;p&gt;⁃ Click on 3 dots button to find &lt;code&gt;Import Data&lt;/code&gt; button in drop down. Click on it to start importing your JSON data to your Google Sheet.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fnrtynnzm8k7g4nnklh9w.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fnrtynnzm8k7g4nnklh9w.png" alt="Sheet Import Data" width="800" height="500"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;⁃ An overlay opens where we are going to convert our JSON data to Google Sheet.&lt;br&gt;
⁃ Paste your data in the &lt;code&gt;GET&lt;/code&gt; input → &lt;a href="https://jsonplaceholder.typicode.com/todos" rel="noopener noreferrer"&gt;https://jsonplaceholder.typicode.com/todos&lt;/a&gt;&lt;br&gt;
⁃ Click on &lt;code&gt;Fetch Data&lt;/code&gt; button.&lt;br&gt;
⁃ Add &lt;code&gt;Id&lt;/code&gt;, &lt;code&gt;title&lt;/code&gt;, &lt;code&gt;completed&lt;/code&gt; to our selective table headings.&lt;br&gt;
⁃ Click on &lt;code&gt;Next Step&lt;/code&gt; button&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fq3nk4dudwtw84q16n2k6.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fq3nk4dudwtw84q16n2k6.png" alt="Sheet fetch Data" width="800" height="500"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;⁃ The drop down &lt;code&gt;Input Table Name &amp;amp; push data&lt;/code&gt; header opens on itself.&lt;br&gt;
⁃ Change the name of heading from &lt;code&gt;completed&lt;/code&gt; to &lt;code&gt;status&lt;/code&gt; like below.&lt;br&gt;
⁃ Select your Sheet API, you created in Step 2.&lt;br&gt;
⁃ Select the empty sheet &lt;code&gt;Sheet2&lt;/code&gt; that gives you a success message.&lt;br&gt;
⁃ Click &lt;code&gt;Push Data&lt;/code&gt; to send your JSON data to Google Sheet.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F0dlu2sz2jennnue7h9yb.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F0dlu2sz2jennnue7h9yb.png" alt="Sheet Push Data" width="800" height="500"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;⁃ Next to Push data you should find your status bar turning green.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Frns4dqgeynr6qmsp7e03.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Frns4dqgeynr6qmsp7e03.png" alt="Sheet Success" width="800" height="430"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;h3&gt;
  
  
  This is it
&lt;/h3&gt;

&lt;p&gt;We have successfully converted our JSON data to Google Sheet. You can fetch your required JSON data to Google Sheet in a similar fashion.&lt;/p&gt;

&lt;p&gt;I hope you liked this article. Help us write better by giving your feedback on our twitter channel at &lt;a href="https://twitter.com/nocodeapi" rel="noopener noreferrer"&gt;@nocodeapi&lt;/a&gt;. Thank you for reading. Happy Coding !! ✌️&lt;/p&gt;

</description>
    </item>
    <item>
      <title>Top 5 JavaScript Courses for Web Development</title>
      <dc:creator>Mohd Danish</dc:creator>
      <pubDate>Sat, 02 Jan 2021 12:31:35 +0000</pubDate>
      <link>https://forem.com/mddanishyusuf/top-5-javascript-courses-for-web-development-15i0</link>
      <guid>https://forem.com/mddanishyusuf/top-5-javascript-courses-for-web-development-15i0</guid>
      <description>&lt;p&gt;Hi, my name is Mohd Danish &amp;amp; Founder of &lt;a href="https://nocodeapi.com" rel="noopener noreferrer"&gt;NoCodeAPI&lt;/a&gt;. In this blog post I'm sharing list of courses those I took to brush up my JavaScript Skills. My online favorite teachers are &lt;strong&gt;Wes Bos&lt;/strong&gt;, &lt;strong&gt;Moshfegh Hamedani&lt;/strong&gt;, &amp;amp; &lt;strong&gt;Jonas Schmedtmann&lt;/strong&gt;.&lt;/p&gt;

&lt;p&gt;There are list of courses:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;a href="https://beginnerjavascript.com/friend/PUBLICAPIS" rel="noopener noreferrer"&gt;Beginner JavaScript&lt;/a&gt; - by Wes Bos&lt;/li&gt;
&lt;li&gt;
&lt;a href="https://codewithmosh.com/p/the-complete-node-js-course" rel="noopener noreferrer"&gt;The Complete Node.js Course&lt;/a&gt; - by Moshfegh Hamedani&lt;/li&gt;
&lt;li&gt;
&lt;a href="https://reactforbeginners.com/friend/PUBLICAPIS" rel="noopener noreferrer"&gt;React for Beginners&lt;/a&gt; - by Wes Bos&lt;/li&gt;
&lt;li&gt;
&lt;a href="https://mastergatsby.com/friend/PUBLICAPIS" rel="noopener noreferrer"&gt;Master Gatsby&lt;/a&gt; - by Wes Bos&lt;/li&gt;
&lt;li&gt;
&lt;a href="https://learnnode.com/friend/PUBLICAPIS" rel="noopener noreferrer"&gt;Learn Node&lt;/a&gt; - by Wes Bos&lt;/li&gt;
&lt;li&gt;
&lt;a href="https://www.udemy.com/course/nodejs-express-mongodb-bootcamp/" rel="noopener noreferrer"&gt;Master Node.js&lt;/a&gt; - by Jonas Schmedtmann&lt;/li&gt;
&lt;/ul&gt;

&lt;h3&gt;
  
  
  Beginner JavaScript
&lt;/h3&gt;

&lt;p&gt;A fun, exercise heavy approach to learning Modern JavaScript from scratch. A rock solid understanding of JavaScript is essential for success, no matter which framework you use. This course will give you that.&lt;/p&gt;

&lt;p&gt;JavaScript is hard to learn. Frustration, abandonment and rage quits all stem from trying to use something when we don't understand how things work.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://beginnerjavascript.com/friend/PUBLICAPIS" rel="noopener noreferrer"&gt;Go to course ↗&lt;/a&gt;&lt;/p&gt;

&lt;h3&gt;
  
  
  The Complete Node.js Course
&lt;/h3&gt;

&lt;p&gt;Want to learn Node.js, but are tired of wordy and slow instructors who talk to you like you've never coded before? A perfect mix of theory and practice with no waffling. Learn to build RESTful APIs with Node, Express and MongoDB with confidence.&lt;/p&gt;

&lt;p&gt;Includes best practices that pros apply, as well as going over common mistakes that many Node.js developers make.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://codewithmosh.com/p/the-complete-node-js-course" rel="noopener noreferrer"&gt;Go to course ↗&lt;/a&gt;&lt;/p&gt;

&lt;h3&gt;
  
  
  React for Beginners
&lt;/h3&gt;

&lt;p&gt;A premium step-by-step training course to get you building real world React.js + Firebase apps and website components.&lt;/p&gt;

&lt;p&gt;With a focus on simplicity and readability, this course will have you building real time applications and dynamic website components in no time!&lt;/p&gt;

&lt;p&gt;Together, we will build “Catch of the Day” — a real-time app for a trendy seafood market where price and quantity available are variable and can change at a moment's notice. We will build a menu, an order form, and an inventory management area where authorized users can immediately update product details.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://reactforbeginners.com/friend/PUBLICAPIS" rel="noopener noreferrer"&gt;Go to course ↗&lt;/a&gt;&lt;/p&gt;

&lt;h3&gt;
  
  
  Master Gatsby
&lt;/h3&gt;

&lt;p&gt;Building modern websites is tough. Preloading, routing, compression, critical CSS, caching, scaling and bundlers all make for blazing fast websites, but extra development and tooling get in the way.&lt;/p&gt;

&lt;p&gt;In this course we also write all the CSS to style the website.&lt;/p&gt;

&lt;p&gt;We will learn fun things like CSS Variables, Layouts with Grid (and sub-grid!), Flexbox, clamp(), @supports queries, transforms, scoping CSS, responsive design and so much more!&lt;/p&gt;

&lt;p&gt;I've recorded it in such a way that the CSS videos are skippable, if you rather not learn some CSS along the way.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://mastergatsby.com/friend/PUBLICAPIS" rel="noopener noreferrer"&gt;Go to course ↗&lt;/a&gt;&lt;/p&gt;

&lt;h3&gt;
  
  
  Learn Node
&lt;/h3&gt;

&lt;p&gt;With a focus on modern JavaScript and real world application, Learn Node is an efficient way to add server side JavaScript to your skill-set and start building the applications you have been dreaming about.&lt;/p&gt;

&lt;p&gt;Together we will build "Now That's Delicious!", a full stack restaurant application which users can search, geolocate, review and curate their favourite restaurants from around the world.&lt;/p&gt;

&lt;p&gt;The application has three main models — Users, Stores and Reviews — all of which are relational. It is designed to hit upon many of today's application needs such as user authentication, database storage, Ajax REST API, file upload and image resizing.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://learnnode.com/friend/PUBLICAPIS" rel="noopener noreferrer"&gt;Go to course ↗&lt;/a&gt;&lt;/p&gt;

&lt;h3&gt;
  
  
  Master Node.js
&lt;/h3&gt;

&lt;p&gt;Master Node by building a real-world RESTful API and web app (with authentication, Node.js security, payments &amp;amp; more)&lt;/p&gt;

&lt;p&gt;Do you want to build fast and powerful back-end applications with JavaScript? Would you like to become a more complete and in-demand developer?&lt;/p&gt;

&lt;p&gt;Then Node.js is the hot technology for you to learn right now, and you came to the right place to do it!&lt;/p&gt;

&lt;p&gt;&lt;a href="https://www.udemy.com/course/nodejs-express-mongodb-bootcamp/" rel="noopener noreferrer"&gt;Go to course ↗&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;This is all. Let us know which course you will go to this year.&lt;/p&gt;

&lt;p&gt;Originally Published on &lt;a href="https://public-apis.io/top-javascript-courses-for-web-development" rel="noopener noreferrer"&gt;Public APIs&lt;/a&gt;&lt;/p&gt;

</description>
      <category>javascript</category>
      <category>courses</category>
      <category>webdev</category>
    </item>
    <item>
      <title>Bypass Airtable API limit and make unlimited requests</title>
      <dc:creator>Mohd Danish</dc:creator>
      <pubDate>Tue, 13 Oct 2020 15:37:58 +0000</pubDate>
      <link>https://forem.com/mddanishyusuf/bypass-airtable-api-limit-and-make-unlimited-requests-3j9f</link>
      <guid>https://forem.com/mddanishyusuf/bypass-airtable-api-limit-and-make-unlimited-requests-3j9f</guid>
      <description>&lt;p&gt;Airtable API is limited to 5 API requests per second for each base table. So, we solved this problem for you with API Plugin. You don't have to set up a server for making proxy &amp;amp; caching logic.&lt;/p&gt;

&lt;h3&gt;
  
  
  What is API Plugin
&lt;/h3&gt;

&lt;p&gt;API Plugin is a tool to connect with third party application API and give simple secure endpoint to use with your tools &amp;amp; projects.&lt;/p&gt;

&lt;p&gt;You can connect with Google Sheet API, Airtable, Instagram, GitHub, YouTube, WordPress, Webflow, Spotify, Twitter, &amp;amp; more. You can view them all in &lt;a href="https://apiplugin.com/marketplace" rel="noopener noreferrer"&gt;The Marketplace&lt;/a&gt;&lt;/p&gt;

&lt;h3&gt;
  
  
  Get Started
&lt;/h3&gt;

&lt;p&gt;First of all, you have to signup on &lt;a href="https://apiplugin.com" rel="noopener noreferrer"&gt;API Plugin&lt;/a&gt; if you are a new user. If you are an existing user of API Plugin then setup Airtable API with API Plugin.&lt;/p&gt;

&lt;p&gt;To setup Airtable API we need 2 values:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;API key&lt;/strong&gt;- You can get your Airtable API key from here &lt;a href="https://airtable.com/account" rel="noopener noreferrer"&gt;https://airtable.com/account&lt;/a&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Base ID&lt;/strong&gt;- Go here &lt;a href="https://airtable.com/api" rel="noopener noreferrer"&gt;https://airtable.com/api&lt;/a&gt; and select your form then you can find the base ID in URL &amp;amp; It begins with the app. Ex: &lt;a href="https://airtable.com/appofMoPxdu7iQ7hf/api/docs-%3E" rel="noopener noreferrer"&gt;https://airtable.com/appofMoPxdu7iQ7hf/api/docs-&amp;gt;&lt;/a&gt; &lt;strong&gt;appofMoPxdu7iQ7hf&lt;/strong&gt; is the base ID.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Now login to API Plugin, go-to the marketplace, &amp;amp; activate the Airtable application. Click on the button &lt;strong&gt;Make Airtable API&lt;/strong&gt; &amp;amp; put the required values into the form.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fi%2Fp00cmp1tya72hkfegwej.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fi%2Fp00cmp1tya72hkfegwej.png" alt="Airtable Form" width="800" height="465"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;When you fill all the values click on the button &lt;strong&gt;Create&lt;/strong&gt;. That's all, your Airtable endpoint ready to use.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fi%2Fys5lry920ksklgdsmjg6.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fi%2Fys5lry920ksklgdsmjg6.png" alt="Airtable API Card" width="800" height="400"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;In-built &lt;strong&gt;playground&lt;/strong&gt; to test these endpoints &amp;amp; &lt;strong&gt;minimal documentation&lt;/strong&gt;.&lt;/p&gt;

&lt;h3&gt;
  
  
  Benefits
&lt;/h3&gt;

&lt;ul&gt;
&lt;li&gt;Your &lt;strong&gt;API Key&lt;/strong&gt; is secured&lt;/li&gt;
&lt;li&gt;Bypass limit - We are using caching technology for this.&lt;/li&gt;
&lt;li&gt;Time-Saving&lt;/li&gt;
&lt;li&gt;API response is Fast.&lt;/li&gt;
&lt;li&gt;You can track all your logs&lt;/li&gt;
&lt;li&gt;No Server Headache&lt;/li&gt;
&lt;li&gt;Mini Documentation&lt;/li&gt;
&lt;/ul&gt;

&lt;h3&gt;
  
  
  Customize Caching
&lt;/h3&gt;

&lt;p&gt;By default, every &lt;strong&gt;GET&lt;/strong&gt; request has 60 seconds of caching means the first API call will come from a third party application API and other API calls under the next 60 seconds from the caching server.&lt;/p&gt;

&lt;p&gt;You can customize the caching time if you are a paid user. Just pass cacheTime(in seconds) as query param with endpoint like this.&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight javascript"&gt;&lt;code&gt;&lt;span class="nx"&gt;https&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="c1"&gt;//v1.apiplugin.com/gitdansih/airtable/ePcgqeUWUNWgmPmN?cacheTime=900&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Now your endpoint will be cached for 900 seconds(15 minutes).&lt;/p&gt;

&lt;p&gt;That's all guys. You can follow us on twitter for updates &lt;a href="https://twitter.com/mddanishyusuf" rel="noopener noreferrer"&gt;Follow on Twitter&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;Thanks.&lt;/p&gt;

&lt;p&gt;Original posted here &lt;a href="https://apiplugin.com/blog/bypass-airtable-api-limit" rel="noopener noreferrer"&gt;https://apiplugin.com/blog/bypass-airtable-api-limit&lt;/a&gt;&lt;/p&gt;

</description>
    </item>
    <item>
      <title>Highly suggested React Course</title>
      <dc:creator>Mohd Danish</dc:creator>
      <pubDate>Thu, 24 Sep 2020 19:41:50 +0000</pubDate>
      <link>https://forem.com/mddanishyusuf/highly-suggested-react-course-5e66</link>
      <guid>https://forem.com/mddanishyusuf/highly-suggested-react-course-5e66</guid>
      <description>&lt;p&gt;Today, I'm sharing highly curated &amp;amp; selected courses to learn React knowledge with practical examples. I started my web development journey with Angular 1.6 in 2016 and this was super easy for me to make projects.&lt;/p&gt;

&lt;p&gt;After playing with Angular for 1 year then I got to know about Reactjs and I dive into this and decide to build something with React.&lt;/p&gt;

&lt;p&gt;So, I was loving React.js &amp;amp; decide to become a master in this. So, I ask some suggestion about which course should I take to learn to React. I took a couple of courses for React &amp;amp; I'm sharing them here.&lt;/p&gt;

&lt;p&gt;I'll only suggest two courses that will make you master in React development journey.&lt;/p&gt;

&lt;h2&gt;
  
  
  &lt;a href="https://ReactForBeginners.com/friend/PUBLICAPIS" rel="noopener noreferrer"&gt;React For Beginners&lt;/a&gt;
&lt;/h2&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fi%2Fkqgijvgdnxe2ksdlf8kn.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fi%2Fkqgijvgdnxe2ksdlf8kn.png" alt="React Begineers" width="800" height="282"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;This is the first course I took to confirm my basic with React that I'm going in the right direction or not. I finished the course in 2 days &amp;amp; in the course 80% new things I learned. &lt;strong&gt;Highly Recommended&lt;/strong&gt;.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://ReactForBeginners.com/friend/PUBLICAPIS" rel="noopener noreferrer"&gt;Link to the course&lt;/a&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  &lt;a href="https://mastergatsby.com/friend/PUBLICAPIS" rel="noopener noreferrer"&gt;Master Gatsby&lt;/a&gt;
&lt;/h2&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fi%2F214fnxjh0al046gpyjdp.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fi%2F214fnxjh0al046gpyjdp.png" alt="Master Gatsby" width="800" height="400"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;If you are a React developer then definitely you know about Gatsby. Gatsby is a React framework to make static websites with lots of built-in features like caching, preloading, &amp;amp; more.&lt;/p&gt;

&lt;p&gt;I was building the Gatsby website for 1.2 years &amp;amp; I made 6-7 Gatsby projects.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://mastergatsby.com/friend/PUBLICAPIS" rel="noopener noreferrer"&gt;Link to the course&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;I can guarantee you that these two courses will worth your single penny. WesBos make these course with the examples that explain code logic in real-time.&lt;/p&gt;

&lt;h2&gt;
  
  
  Questions:
&lt;/h2&gt;

&lt;p&gt;Please leave the comment with your recommended courses. Thanks&lt;/p&gt;

</description>
      <category>react</category>
      <category>tutorial</category>
      <category>javascript</category>
    </item>
    <item>
      <title>Get Instagram Feed Data without Code</title>
      <dc:creator>Mohd Danish</dc:creator>
      <pubDate>Fri, 07 Aug 2020 11:51:38 +0000</pubDate>
      <link>https://forem.com/mddanishyusuf/get-instagram-feed-data-without-code-1df7</link>
      <guid>https://forem.com/mddanishyusuf/get-instagram-feed-data-without-code-1df7</guid>
      <description>&lt;p&gt;Ever had to access Instagram API and had to go through the confusing facebook docs, I have seen a friend go through the Facebook docs for hours and still not able to get it working.  We need an easier way to access Instagram API, it could be to embed it on our portfolio or basically to do anything with it. &lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fi%2Fesgjssiai5cvu3omzyte.gif" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fi%2Fesgjssiai5cvu3omzyte.gif" alt="Gif" width="248" height="200"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;Me trying to understand Facebook docs.&lt;/p&gt;

&lt;p&gt;So yeah, this is exactly what we are trying to solve with &lt;a href="https://instafeedapi.com" rel="noopener noreferrer"&gt;InstaFeedAPI&lt;/a&gt;, no need to go through the confusing docs or read every single thing and pass weird parameters with no explanation to get your own feed.&lt;/p&gt;

&lt;p&gt;So we have read the docs for you &amp;amp; we have done it the right way, all you need is the token for your Instagram account and that's it (literally). You just paste it in our dashboard and get an API.&lt;/p&gt;

&lt;h3&gt;
  
  
  What are we doing today?
&lt;/h3&gt;

&lt;ol&gt;
&lt;li&gt;Get your Instagram Long-lived token&lt;/li&gt;
&lt;li&gt;Fill a two-step form&lt;/li&gt;
&lt;li&gt;Voila, you have an Instagram feed API ready.&lt;/li&gt;
&lt;/ol&gt;

&lt;h2&gt;
  
  
  Get the token
&lt;/h2&gt;

&lt;h3&gt;
  
  
  1. Make a Facebook app
&lt;/h3&gt;

&lt;p&gt;Open Facebook Developer portal &lt;br&gt;
&lt;a href="https://developers.facebook.com/apps/" rel="noopener noreferrer"&gt;https://developers.facebook.com/apps/&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;If you're doing this for the first time, join the FB developers portal by logging in.&lt;/p&gt;

&lt;p&gt;Click on &lt;strong&gt;Get Started on top&lt;/strong&gt; -&amp;gt; &lt;strong&gt;Verify your account&lt;/strong&gt;&lt;/p&gt;

&lt;p&gt;After clicking on &lt;strong&gt;Create App&lt;/strong&gt;, click on &lt;strong&gt;"For Everything Else"&lt;/strong&gt; from the popup. Give your App a Name.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fi%2F0ydb65laghkukpg844a1.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fi%2F0ydb65laghkukpg844a1.png" alt="Instagram APP" width="596" height="240"&gt;&lt;/a&gt;&lt;/p&gt;
&lt;h3&gt;
  
  
  2. Add Instagram Testers
&lt;/h3&gt;

&lt;p&gt;Now select &lt;strong&gt;Instagram&lt;/strong&gt; from the set of Facebook products, as we want the Instagram feed. &lt;/p&gt;

&lt;p&gt;You will be taken to an agreement page, select &lt;strong&gt;Basic Display&lt;/strong&gt; from the sidebar click on &lt;strong&gt;Create App&lt;/strong&gt;, give it a name again and you will now be seeing the Instagram developer console.&lt;/p&gt;

&lt;p&gt;Scroll down and you will be able to see a section called &lt;strong&gt;User Token Generator&lt;/strong&gt; &amp;amp; Click on &lt;strong&gt;Add or Remove Instagram Testers.&lt;/strong&gt; &lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fi%2Fvpu3fayg3a07y5ztapoe.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fi%2Fvpu3fayg3a07y5ztapoe.png" alt="Add Tester" width="800" height="289"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;Scroll down and add the Instagram username of whose feed you want in the API, &lt;strong&gt;this only works for accounts that are set as public and you will not be able to access private accounts.&lt;/strong&gt;&lt;/p&gt;

&lt;p&gt;Let's add our own account username and accept the testing invite by accessing this link &lt;a href="https://www.instagram.com/accounts/manage_access/" rel="noopener noreferrer"&gt;&lt;code&gt;https://www.instagram.com/accounts/manage_access/&lt;/code&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;Once done come back to the Facebook developer portal, open your app, click on &lt;strong&gt;Basic Display&lt;/strong&gt; and click &lt;strong&gt;Generate Token&lt;/strong&gt;. &lt;/p&gt;

&lt;p&gt;You now have finally generated an &lt;strong&gt;Instagram access token&lt;/strong&gt;, keep this somewhere aside.&lt;/p&gt;
&lt;h3&gt;
  
  
  Video Tutorial about getting Token
&lt;/h3&gt;

&lt;p&gt;&lt;iframe width="710" height="399" src="https://www.youtube.com/embed/UhAe_pY1_I8"&gt;
&lt;/iframe&gt;
&lt;/p&gt;

&lt;h2&gt;
  
  
  Insta Feed API.
&lt;/h2&gt;

&lt;p&gt;So, all you have to do is create an account in &lt;a href="https://instafeedapi.com/signup" rel="noopener noreferrer"&gt;https://instafeedapi.com/signup&lt;/a&gt; and give yourself a username. &lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fi%2Frkgz7jyj7d6swhgai3aw.jpeg" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fi%2Frkgz7jyj7d6swhgai3aw.jpeg" alt="Setup Account" width="800" height="450"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;Click on Create Instagram API button, once done you will be seeing a form like below, just give your API a name and enter your Instagram token.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fi%2F1vopoeccpdb4jhk500nk.jpeg" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fi%2F1vopoeccpdb4jhk500nk.jpeg" alt="Make API" width="800" height="450"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;Your API will be listed and you can create more APIs with different accounts if you like.&lt;/p&gt;

&lt;p&gt;Click on the API and there you have it an API endpoint which will return you a list of your Instagram feed in a clean JSON format.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fi%2F4tgfjk28ts7tbxpqwvdh.jpeg" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fi%2F4tgfjk28ts7tbxpqwvdh.jpeg" alt="InstaFeedAPI docs" width="800" height="450"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;You can also pass limit, before &amp;amp; after parameters to our endpoint to have quick filters.&lt;/p&gt;

&lt;p&gt;Website: &lt;a href="https://instafeedapi.com" rel="noopener noreferrer"&gt;https://instafeedapi.com&lt;/a&gt;&lt;br&gt;
Pricing Page: &lt;a href="https://instafeedapi.com/pricing" rel="noopener noreferrer"&gt;https://instafeedapi.com/pricing&lt;/a&gt;&lt;/p&gt;

</description>
      <category>api</category>
      <category>instagram</category>
      <category>feed</category>
      <category>nocode</category>
    </item>
    <item>
      <title>The easiest way to use Google Sheet API</title>
      <dc:creator>Mohd Danish</dc:creator>
      <pubDate>Thu, 14 May 2020 12:38:14 +0000</pubDate>
      <link>https://forem.com/mddanishyusuf/the-easiest-way-to-use-google-sheet-api-53lp</link>
      <guid>https://forem.com/mddanishyusuf/the-easiest-way-to-use-google-sheet-api-53lp</guid>
      <description>&lt;p&gt;Using Google Sheet API is very basic with NoCodeAPI. We make the process to access data from your google sheet is so easy and quick. Just authenticate with your Google account and rest we will do for you.&lt;/p&gt;

&lt;p&gt;There are the following reasons we build this tool to &lt;strong&gt;Save your Time&lt;/strong&gt; by building your backend.&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Write API endpoint with your framework(express, Django, Ruby on Rail, etc)&lt;/li&gt;
&lt;li&gt;Secure Access Token&lt;/li&gt;
&lt;li&gt;Maintain Server&lt;/li&gt;
&lt;li&gt;Config caching technology to make API faster&lt;/li&gt;
&lt;li&gt;Figure out complex documentation&lt;/li&gt;
&lt;li&gt;Build your own logs system to visualize your APIs&lt;/li&gt;
&lt;li&gt;Required more time to do all these things.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;With &lt;strong&gt;NoCodeAPI&lt;/strong&gt; you can access, update, and delete your google sheet data in 2 minutes with many built-in features:&lt;/p&gt;

&lt;h3&gt;
  
  
  Setup Sheet API
&lt;/h3&gt;

&lt;p&gt;I'm assuming that you already signup on &lt;a href="https://nocodeapi.com" rel="noopener noreferrer"&gt;NoCodeAPI&lt;/a&gt;. If not then first make an account there and activate Google Sheet API from Marketplace. Follow this article for a quick setup. &lt;a href="https://nocodeapi.com/docs/google-sheets-nocode-api-docs" rel="noopener noreferrer"&gt;Setup Google Sheet API&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;When you will finish your Google Sheet API then you will see this card with your sheet secure API endpoint.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fi%2Fbvxj94dn7j4ut7aybxxm.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fi%2Fbvxj94dn7j4ut7aybxxm.png" alt="Google Sheet API Card" width="800" height="232"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  Use API Endpoints:
&lt;/h2&gt;

&lt;p&gt;With Google sheet API you can do:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Get rows&lt;/strong&gt; &lt;small&gt;(GET Request)&lt;/small&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Get single row&lt;/strong&gt; &lt;small&gt;(GET Request)&lt;/small&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Add new row&lt;/strong&gt; &lt;small&gt;(POST Request)&lt;/small&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Update a row&lt;/strong&gt; &lt;small&gt;(PUT Request)&lt;/small&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Delete a row&lt;/strong&gt; &lt;small&gt;(DELETE Request)&lt;/small&gt;
&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;&lt;strong&gt;Note&lt;/strong&gt;: I'll use the CURL command for the demo.&lt;/p&gt;

&lt;p&gt;In one Google spreadsheet, you can add multiple tabs, and first, you have to know the tab name of which you want to use API. On the bottom, you can see your all tab's names. In this image &lt;code&gt;api-database&lt;/code&gt;, &lt;code&gt;lists&lt;/code&gt; &amp;amp; &lt;code&gt;Sheet2&lt;/code&gt; are &lt;strong&gt;tabId&lt;/strong&gt;.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fi%2Fck8b5cqnljs0me7ef2gb.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fi%2Fck8b5cqnljs0me7ef2gb.png" alt="Tab Names" width="800" height="209"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;h3&gt;
  
  
  #Get rows
&lt;/h3&gt;

&lt;p&gt;To get your sheet rows to make a &lt;code&gt;GET&lt;/code&gt; call to your endpoint with &lt;code&gt;tabId&lt;/code&gt; query params and it will return your data as &lt;code&gt;JSON&lt;/code&gt;.&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight json"&gt;&lt;code&gt;&lt;span class="err"&gt;curl&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="err"&gt;https://v&lt;/span&gt;&lt;span class="mi"&gt;1&lt;/span&gt;&lt;span class="err"&gt;.nocodeapi.com/betauser/google_sheets/mLjulmxwQuctZXNl?tabId=&amp;lt;tabId&amp;gt;&lt;/span&gt;&lt;span class="w"&gt;
&lt;/span&gt;&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Here is the result that will be consoled as JSON.&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight json"&gt;&lt;code&gt;&lt;span class="p"&gt;{&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"data"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="w"&gt;
    &lt;/span&gt;&lt;span class="p"&gt;{&lt;/span&gt;&lt;span class="w"&gt;
      &lt;/span&gt;&lt;span class="nl"&gt;"row_id"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="mi"&gt;2&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
      &lt;/span&gt;&lt;span class="nl"&gt;"name"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"NoCodeAPI"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
      &lt;/span&gt;&lt;span class="nl"&gt;"link"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"https://nocodeapi.com"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
      &lt;/span&gt;&lt;span class="nl"&gt;"description"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"Quick and Easy API Gateway for your favorite Applications"&lt;/span&gt;&lt;span class="w"&gt;
    &lt;/span&gt;&lt;span class="p"&gt;},&lt;/span&gt;&lt;span class="w"&gt;
    &lt;/span&gt;&lt;span class="p"&gt;{&lt;/span&gt;&lt;span class="w"&gt;
      &lt;/span&gt;&lt;span class="nl"&gt;"row_id"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="mi"&gt;3&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
      &lt;/span&gt;&lt;span class="nl"&gt;"name"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"Public APIs"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
      &lt;/span&gt;&lt;span class="nl"&gt;"link"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"https://public-apis.io"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
      &lt;/span&gt;&lt;span class="nl"&gt;"description"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"A collection of public APIs for software developers "&lt;/span&gt;&lt;span class="w"&gt;
    &lt;/span&gt;&lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="p"&gt;],&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"total"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="mi"&gt;2&lt;/span&gt;&lt;span class="w"&gt;
&lt;/span&gt;&lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="w"&gt;
&lt;/span&gt;&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h3&gt;
  
  
  #Get single row
&lt;/h3&gt;

&lt;p&gt;To get a single row from sheet make a &lt;code&gt;GET&lt;/code&gt; call to your endpoint with &lt;code&gt;tabId&lt;/code&gt; &amp;amp; &lt;code&gt;row_id&lt;/code&gt; query params and it will return single data object as &lt;code&gt;JSON&lt;/code&gt;.&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight json"&gt;&lt;code&gt;&lt;span class="err"&gt;curl&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="err"&gt;https://v&lt;/span&gt;&lt;span class="mi"&gt;1&lt;/span&gt;&lt;span class="err"&gt;.nocodeapi.com/betauser/google_sheets/mLjulmxwQuctZXNl?tabId=&amp;lt;tabId&amp;gt;&amp;amp;row_id=&amp;lt;row_id&amp;gt;&lt;/span&gt;&lt;span class="w"&gt;
&lt;/span&gt;&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Here is a result you will get.&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight json"&gt;&lt;code&gt;&lt;span class="p"&gt;{&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"row_id"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="mi"&gt;2&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"name"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"NoCodeAPI"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"link"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"https://nocodeapi.com"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"description"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"Quick and Easy API Gateway for your favorite Applications"&lt;/span&gt;&lt;span class="w"&gt;
&lt;/span&gt;&lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="w"&gt;
&lt;/span&gt;&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h3&gt;
  
  
  #Add new row
&lt;/h3&gt;

&lt;p&gt;To add a new row in your google sheet you have made a &lt;code&gt;POST&lt;/code&gt; call with Array of rows into &lt;code&gt;body&lt;/code&gt;&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight json"&gt;&lt;code&gt;&lt;span class="err"&gt;curl&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="err"&gt;--request&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="err"&gt;POST&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"https://v1.nocodeapi.com/betauser/google_sheets/mLjulmxwQuctZXNl?tabId=&amp;lt;tabId&amp;gt;"&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="err"&gt;\&lt;/span&gt;&lt;span class="w"&gt;
&lt;/span&gt;&lt;span class="err"&gt;-H&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"Content-Type: application/json"&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="err"&gt;\&lt;/span&gt;&lt;span class="w"&gt;
&lt;/span&gt;&lt;span class="err"&gt;--data&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="err"&gt;'&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="w"&gt;
    &lt;/span&gt;&lt;span class="s2"&gt;"Producthunt"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
    &lt;/span&gt;&lt;span class="s2"&gt;"https://producthunt.com"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
    &lt;/span&gt;&lt;span class="s2"&gt;"A website to launch new products"&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="p"&gt;],&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="w"&gt;
    &lt;/span&gt;&lt;span class="s2"&gt;"Twitter"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
    &lt;/span&gt;&lt;span class="s2"&gt;"https://twitter.com"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
    &lt;/span&gt;&lt;span class="s2"&gt;"A Social networking plateform for peoples"&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt;&lt;span class="w"&gt;
&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt;&lt;span class="err"&gt;'&lt;/span&gt;&lt;span class="w"&gt;
&lt;/span&gt;&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;When you hit this command into the terminal then you will get this message:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight json"&gt;&lt;code&gt;&lt;span class="p"&gt;{&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="nl"&gt;"message"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"Successfully Inserted"&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="w"&gt;
&lt;/span&gt;&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h3&gt;
  
  
  #Update row
&lt;/h3&gt;

&lt;p&gt;To update a row in your google sheet you have made a &lt;code&gt;PUT&lt;/code&gt; call with object data into &lt;code&gt;body&lt;/code&gt;&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight json"&gt;&lt;code&gt;&lt;span class="err"&gt;curl&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="err"&gt;--request&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="err"&gt;PUT&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"https://v1.nocodeapi.com/betauser/google_sheets/mLjulmxwQuctZXNl?tabId=&amp;lt;tabId&amp;gt;"&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="err"&gt;\&lt;/span&gt;&lt;span class="w"&gt;
&lt;/span&gt;&lt;span class="err"&gt;-H&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"Content-Type: application/json"&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="err"&gt;\&lt;/span&gt;&lt;span class="w"&gt;
&lt;/span&gt;&lt;span class="err"&gt;--data-raw&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="err"&gt;'&lt;/span&gt;&lt;span class="p"&gt;{&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"row_id"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="mi"&gt;3&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"name"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"Producthunt 3"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"link"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"https://producthunt.com"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="w"&gt;
  &lt;/span&gt;&lt;span class="nl"&gt;"description"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"A website to launch new products"&lt;/span&gt;&lt;span class="w"&gt;
&lt;/span&gt;&lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="err"&gt;'&lt;/span&gt;&lt;span class="w"&gt;
&lt;/span&gt;&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;When you hit this command into the terminal then you will get this message:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight json"&gt;&lt;code&gt;&lt;span class="p"&gt;{&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="nl"&gt;"message"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"Updated successfully"&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="w"&gt;
&lt;/span&gt;&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h3&gt;
  
  
  #Delete row
&lt;/h3&gt;

&lt;p&gt;To delete one row from your google sheet you have made a &lt;code&gt;DELETE&lt;/code&gt; call with &lt;code&gt;tabId&lt;/code&gt; &amp;amp; &lt;code&gt;row_id&lt;/code&gt; query params.&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight json"&gt;&lt;code&gt;&lt;span class="err"&gt;curl&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="err"&gt;--request&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="err"&gt;DELETE&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="err"&gt;https://v&lt;/span&gt;&lt;span class="mi"&gt;1&lt;/span&gt;&lt;span class="err"&gt;.nocodeapi.com/betauser/google_sheets/mLjulmxwQuctZXNl?tabId=&amp;lt;tabId&amp;gt;&amp;amp;row_id=&amp;lt;row_id&amp;gt;&lt;/span&gt;&lt;span class="w"&gt;
&lt;/span&gt;&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;When you hit this command into the terminal then you will get this message:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight json"&gt;&lt;code&gt;&lt;span class="p"&gt;{&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="nl"&gt;"message"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="s2"&gt;"Deleted successfully"&lt;/span&gt;&lt;span class="w"&gt; &lt;/span&gt;&lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="w"&gt;
&lt;/span&gt;&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;We did it.&lt;/p&gt;

&lt;p&gt;&lt;em&gt;Originally published at &lt;a href="https://nocodeapi.com/google-sheet-api" rel="noopener noreferrer"&gt;nocodeapi.com&lt;/a&gt;&lt;/em&gt;&lt;/p&gt;

&lt;p&gt;Yes, That's all. If you have any other use cases then let us know about that. So, we can make a blog post about that.&lt;/p&gt;

&lt;p&gt;More useful links:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;&lt;a href="https://nocodeapi.com/telegram-bot-with-nocode-and-get-notifications" rel="noopener noreferrer"&gt;Build Telegram Bot without code and get notifications&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://nocodeapi.com/free-website-status-page-with-uptime-robot-and-zeit" rel="noopener noreferrer"&gt;Website Status Page with Uptime Robot &amp;amp; Zeit&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://nocodeapi.com/collect-website-data-with-react-and-airtable-nocodeapi" rel="noopener noreferrer"&gt;Collect website data with React &amp;amp; Airtable NoCodeAPI&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://nocodeapi.com/get-user-leads-data-into-telegram" rel="noopener noreferrer"&gt;Get User Leads data into Telegram&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://nocodeapi.com/use-cases" rel="noopener noreferrer"&gt;More use cases&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;

</description>
      <category>webdev</category>
      <category>google</category>
      <category>sheet</category>
      <category>api</category>
    </item>
    <item>
      <title>Build Telegram Bot without code and get notifications</title>
      <dc:creator>Mohd Danish</dc:creator>
      <pubDate>Mon, 04 May 2020 10:53:33 +0000</pubDate>
      <link>https://forem.com/mddanishyusuf/build-telegram-bot-without-code-and-get-notifications-27aj</link>
      <guid>https://forem.com/mddanishyusuf/build-telegram-bot-without-code-and-get-notifications-27aj</guid>
      <description>&lt;p&gt;Telegram is the most used mobile messaging tool in daily life. So, build telegram bot and get a notification for netlify build, stripe payments, etc.&lt;/p&gt;

&lt;p&gt;Let's build Telegram API first without any code and server setup and we need two values to make this.&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Bot Token key&lt;/li&gt;
&lt;li&gt;Chat ID&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Make a Telegram Bot
&lt;/h2&gt;

&lt;p&gt;&lt;b&gt;To get bot token&lt;/b&gt;, you have to make a telegram bot with Botfather tool. Search for the &lt;code&gt;botfather&lt;/code&gt; in your telegram and add this.&lt;/p&gt;

&lt;p&gt;Now pass &lt;code&gt;/newbot&lt;/code&gt; command to make a new bot, give a name, and username to the bot as following.&lt;/p&gt;

&lt;p&gt;After that, you will get your &lt;code&gt;Bot Token Key&lt;/code&gt;.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fi%2F6h5e8wbuoodngu9gpy7f.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fi%2F6h5e8wbuoodngu9gpy7f.png" alt="Telegram Bot Key" width="800" height="149"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;b&gt;To get Chat ID&lt;/b&gt;, go to your bot channel and send some random message and then replace bot_access_token with your bot key in this URL.&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight javascript"&gt;&lt;code&gt;&lt;span class="nx"&gt;https&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="c1"&gt;//api.telegram.org/bot&amp;lt;bot_access_token&amp;gt;/getUpdates&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Open this URL into the browser and it will return a JSON response with Chat ID.&lt;/p&gt;

&lt;p&gt;Now you got &lt;code&gt;Bot Token Key&lt;/code&gt; &amp;amp; &lt;code&gt;Chat ID&lt;/code&gt;.&lt;/p&gt;

&lt;h2&gt;
  
  
  Setup Telegram API
&lt;/h2&gt;

&lt;p&gt;To make Telegram API without any backend coding and server setup, we are using NoCodeAPI tool. So, sign-up on &lt;a href="https://nocodeapi.com/" rel="noopener noreferrer"&gt;nocodeapi.com&lt;/a&gt; if you have not done yet. Go to Marketplace and activate Telegram API.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fi%2Fxc17um35rdcpkydw14fa.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fi%2Fxc17um35rdcpkydw14fa.png" alt="Telegram Card" width="800" height="443"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;Click on &lt;code&gt;Create Telegram Webhook API&lt;/code&gt; and you will see and form to give API name, Bot Token Key, and Chat ID. After filling all these values click on the &lt;code&gt;Create&lt;/code&gt; button.&lt;/p&gt;

&lt;p&gt;Now your Telegram API is ready and you use to send &lt;code&gt;JSON object&lt;/code&gt;, &lt;code&gt;Text&lt;/code&gt;, or &lt;code&gt;Link&lt;/code&gt; into your Telegram Bot.&lt;/p&gt;

&lt;p&gt;I'm using for the following notification:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Netlify Build Notification&lt;/li&gt;
&lt;li&gt;New Meeting booked on Calendly&lt;/li&gt;
&lt;li&gt;New user on Stripe&lt;/li&gt;
&lt;li&gt;Website Down/UP with Uptime Robot&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Many services support hooks. You can get direct notification into your telegram.&lt;/p&gt;

&lt;h2&gt;
  
  
  Setup Netlify Hook
&lt;/h2&gt;

&lt;p&gt;Go to &lt;code&gt;https://app.netlify.com/&lt;/code&gt; and select the site for which you want to set up a hook. Now go to &lt;code&gt;Settings -&amp;gt; Build &amp;amp; Deploy -&amp;gt; Deploy Notification&lt;/code&gt; and click on Add Notification. You will see a list of notification methods. Click on the &lt;code&gt;Outgoing webhook&lt;/code&gt;.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fi%2Fps37ycadpmtvk2pkayvx.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fi%2Fps37ycadpmtvk2pkayvx.png" alt="Netlify Hook" width="800" height="328"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;You will see now a form to choose the process.&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;code&gt;Event to listen for&lt;/code&gt; - Deploy started, Deploy success, etc.&lt;/li&gt;
&lt;li&gt;
&lt;code&gt;URL to notify&lt;/code&gt;- Put your telegram API there.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;And &lt;code&gt;Save&lt;/code&gt;. That's all.&lt;/p&gt;

&lt;p&gt;Now your Hook setup is ready for Netlify. You can also do with other services as same.&lt;/p&gt;

&lt;p&gt;If you wanna build more API like:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Google Sheet&lt;/li&gt;
&lt;li&gt;Google Analytics&lt;/li&gt;
&lt;li&gt;Airtable&lt;/li&gt;
&lt;li&gt;Instagram&lt;/li&gt;
&lt;li&gt;Slack&lt;/li&gt;
&lt;li&gt;Link Preview API&lt;/li&gt;
&lt;li&gt;Cloudinary&lt;/li&gt;
&lt;li&gt;Open Weather&lt;/li&gt;
&lt;li&gt;More...&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;You can upgrade to pro account of &lt;a href="https://nocodeapi.com/pricing" rel="noopener noreferrer"&gt;NoCodeAPI&lt;/a&gt; with 80% off on yearly subscription for a limited time.&lt;br&gt;
&lt;a href="https://nocodeapi.com/pricing" rel="noopener noreferrer"&gt;&lt;br&gt;
&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fi%2Fm7ifrq3y7ma8bdldpwj0.png" alt="NoCodeAPI pricing" width="800" height="426"&gt;&lt;br&gt;
&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;Here you can also see the video to make Telegram API with NoCodeAPI.&lt;/p&gt;

&lt;p&gt;&lt;iframe width="710" height="399" src="https://www.youtube.com/embed/VsMwi7XXcEQ"&gt;
&lt;/iframe&gt;
&lt;/p&gt;

&lt;p&gt;Yes, That's all. I hope you didn't find any typos in this blog post. if there is any then just drop me the feedback. Thanks :)&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Originally Published&lt;/strong&gt; @ &lt;a href="https://nocodeapi.com/telegram-bot-with-nocode-and-get-notifications" rel="noopener noreferrer"&gt;https://nocodeapi.com/telegram-bot-with-nocode-and-get-notifications&lt;/a&gt;&lt;/p&gt;

</description>
      <category>telegram</category>
      <category>automation</category>
      <category>tool</category>
      <category>webdev</category>
    </item>
  </channel>
</rss>
