How to use Utilitites in airtable script

Question

var authHeader = "Basic " + Utilities.base64Encode(wordpressUsername + ":" + wordpressPassword); I am getting error at "Utilities"  saying"Cannot find name 'Utilities'"  . I need to send post to wordpress using it's rest api and Utilities is required for it's authorization . Kindly help me , any information  regarding this will be great. Thankyou

Stephen_Orr1 · Accepted Answer

It looks like you may be trying to use a Utilities object from some external library. Try btoa() insteadhttps://developer.mozilla.org/en-US/docs/Web/API/btoa

saadat · Answer

It looks like you may be trying to use a Utilities object from some external library. Try btoa() instead
https://developer.mozilla.org/en-US/docs/Web/API/btoa

Thanks , I already tried and it worked but now as I am using wordpress rest api and tring to Post the blog getting 401 error , as code is all correct donot know what is reason , credentials and endpoints etc all are correct because this was working fine in google app script.

getting this response "

{type: "basic", url: "https://philodendroncare.com/wp-json/wp/v2/posts", status: 401, statusText: "Unauthorized", ok: false…}
1. type: "basic"
2. url: "https://philodendroncare.com/wp-json/wp/v2/posts"
3. status: 401
4. statusText: "Unauthorized"
5. ok: false
6. headers: Object
7. redirected: false"

async  function createBlogPost(title, content, status) {
  var wordpressUrl = "";
  var wordpressUsername = "";
  var wordpressPassword = "";
  
  var authHeader = 'Basic ' + btoa(wordpressUsername + ':' + wordpressPassword);
  
  // Create the blog post payload
  var postPayload = {
    title: title,
    content: content,
    status: status
  };

  // Convert the payload to JSON
  var payloadJson = JSON.stringify(postPayload);

  // Make an HTTP POST request to create the blog post
  var url = wordpressUrl + "/wp/v2/posts";
  
  var options = {
    method: "post",
    headers: {
      'Authorization': authHeader,
      'Content-Type': 'application/json'
    },
    body: payloadJson
  };

  await remoteFetchAsync(url, options)
    .then(response => {
        console.log(response)
      if (response.ok) {
        return response.json();
      } else {
        throw new Error("Error creating blog post. Status code: " + response.status);
      }
    })
    .then(data => {
      var postId = data.id;
      console.log("Blog post created with ID: " + postId);
    })
    .catch(error => {
      console.error(error.message);
    });
}

// Example usage
var title = "New Blog Post";
var content = "This is the content of the blog post.";
var status = "publish";

 await createBlogPost(title, content, status);

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded