Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Insert in DB airtable (since FM14) v4.42

Featured Replies

Hi

anyone has any advice, I need to create a record (since FM) in a DB Airtable (ideal use a function ScriptMaster). Airtable publishes ws to Create Record (curl and js)

use library groovy wslite, I try with :

->      header{'Authorization:Bearer key***************'}

->      header{Authorization('Bearer key***************')}

->      header{'Authorization':'Bearer key***************'}

->      header{'api_key=key***************'}

->     header{'api_key=Bearer key***************'}

->     header{Authorization('Bearer key***************')}

 

MESSAGE ERROR !!

________________________________________________

 

wslite.soap.SOAPClientException: 401 Unauthorized

 

Parameters:

wsdl=https://api.airtable.com/v0/appscSNuNhEFXmAc9/bdair, fecha=2016-02-28, fechahora=2016-02-01T04:30:00.000Z, in=abc, d=18, out=xyz, response=<inicio>we</inicio>

 

________________________________________________________

 

anyone know how must be authorization data?

 

Regards

rodlan

The AirTable API requires authorization as a header, not a SOAP header. You call it in the parameter list for client.send, like so:

def response = client.send(SOAPAction:'...example',headers:["Authorization":"Bearer APIKEY"]) {
}

 

  • Author
23 hours ago, rodland said:

thank you very much ... Caleb360Works, the error disappears.

 

after sending my first message,I had tried to do validation using RESTClient using:   

 

import wslite.http.auth.*

 

  client.authorization = new HTTPBasicAuthorization('Authorization','Bearer key...........')

 

Apparently it would also be valid.

 

 

Question: 

 

how serious the syntax in the Script zone (ScriptMaster) of the next structure ?

 

 

____________________________________________________________________

considering ...

 

 

AIRTABLE (JS)

base('namBDairtable').create({ 

"nameparameter1": "valueParameter1", 

"nameparameter2": "valueParameter2", 

"nameparameter3": "valueParameter3", 

"nameparameter4": "valueParameter4", 

"nameparameter5": "valueParameter5", 

"nameparameter6": "valueParameter6" }

 

and

 

AIRTABLE (CURL)

'{ "fields”: 

 "nameparameter1": "valueParameter1”, 

 "nameparameter2": "valueParameter2”, 

 "nameparameter3": "valueParameter3”, 

 "nameparameter4": "valueParameter4”, 

 "nameparameter5": "valueParameter5”, 

 "nameparameter6": "valueParameter6” 

}'

____________________________________________________________

previously used this structure to pass parameters to a post, this not run in this case.

 

 

      body { 

                       name{[

                             nameparameter1(valueParameter1),

                             nameparameter2(valueParameter2),

                             nameparameter3(valueParameter3)

                           ]} 

                       nameparameter4(valueParameter4)

                       nameparameter5(valueParameter5)

                   }

 

_______________________________________________________________

... or where I can read about script master syntax.

        '-> "
        : -> =
        array -> name array {[name1 (value1) name2 (vale2) ... etc]}
        fields -> nameField:

        ...etc.

again thank you very much Caleb360Works

 

Regards

rodland

 

 

23 hours ago, rodland said:

 

Regards

rodlan

 

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.