Skip to main content

API & JSON strings

  • September 13, 2023
  • 1 reply
  • 17 views
J
Forum|alt.badge.img+8

Hey Everyone

I have a problem when collecting data thru API, in this example records of a foodmeny in Airtable. Every dish and the different infos (ID, Day & Date, Swedish, English, Allergens) is formated in a formula field in Airtable. One per dish. In this example its 6 different dishes and I want the output in the API to look one of the examples in Picture 1, but I can't get it like that I only get like Picture 2, were its different strings.

Any advice how to set this up in Airtable and the Api call?

Regards Jesper

1 reply

ScottWorld
Forum|alt.badge.img+33
  • ScottWorld
  • Brainy
  • 8768 replies
  • September 13, 2023

There are 3 different ways that you can generate perfect JSON code from your Airtable data, and then you can use that JSON code to tap into REST APIs:

1. High-code: Writing your own custom Javascript scripts in Airtable.


2. Medium-code: Using DataFetcher.com

3. Low-code: Using Make, which can automatically aggregate Airtable records to JSON and then send the resulting JSON to any REST API that you would like using their built-in app modules or their HTTP module. There is a small learning curve with Make, which is why I created this basic navigation video to help.

p.s. If you have a budget for your project and you’d like to hire an expert Airtable consultant to help you with any of this, please feel free to contact me through my website: Airtable consulting — ScottWorld  

 

 

 

 

 

 

 

 

 

 

Reply


Most helpful members this week

Terms & Conditions