scripting – Pulling data from websites using their API in google sheets?

I’m trying to use the Blizzard API to pull data into a google sheets document. I’m starting to dig into the documentation on scripting in google sheets using a curl request as suggested by the Blizzard API. The initial issue I’m seeing is that I don’t understand how to make a curl request in this scripting. Are there any resources that I can use to better understand this type of process?

magento2 – Magento 2 API usage internally

i am doing several custom modules in Magento 2.

It is a good practice do all the thing orientated to API (thinking in be consume for an mobile app for example ) and also use those api internally in the view model?

Or should i create a controller for return json to the view model and API just for external calls?

For example, i want to show a popup with a list of products using KOjs.

should i use a controller to return the products of that AJAX call o can i use the magento 2 API “rest/V1/products”

sharepoint online – how to handle optional value in rest api post in Msflow

Hi i am updating people picker , managed metadata column in SharePoint using powerautoamte send http request to Sharepoint now few fields is optional when this fields go empty it throw error , how can we handle this type of value below is my Rest call body

Method is post

        "formValues": (

Dynadot Reseller API

We have a premium reseller account on Resellerclub and paid tens of thousands of dollars deposit. But still their domain prices more expensi… | Read the rest of

request – Problema API pagseguro em JAVASCRIPT

Estou fazendo um projeto para minha Lean Startup e para entender melhor como funciona a API do PagSeguro, resolvi testar. Atualmente a API projeto todo está em NODEJS. Fiz muitas pesquisas e só encontrei tutoriais em PHP para usar o pagseguro.

Tentei varias vezes e de diferentes formas fazer o request de checkout, para ver como ficava na minha aplicação o LIGHTBOX do pagseguro.

Infelizmente só tive erros e frustrações.
Abaixo é o que estou usando para fazer a request na API

const request = require("request");
const parseString = require("xml2js").parseString;

aqui segue o código na função que chama na API NODEJS para “Pegar o checkout da pagseguro”

async getProduct(req, res) {
var plano = req.body;
let url_endpoint = "application/x-www-form-urlencoded;charset=ISO-8859-1"
data= {
  email : 'email.....',
  token: 'token sandbox....',
  currency: 'BRL',
  itemId1: '0001',
  itemDescription1: 'PRODUTO 1',
  itemAmount1: '2250.00', //Sempre com decimais
  itemQuantity1: '1',
  itemWeight1: '100',
  itemId2: '0002',
  itemDescription2: 'PRODUTO 2',
  itemAmount2: '35.00', //Sempre com decimais
  itemQuantity2: '2',
  itemWeight2: '750',
  reference: 'REF1234',
  senderName: 'Jose Comprador',
  senderAreaCode: '11',
  senderPhone: '56713293',
  senderEmail: '',
  shippingType: '1', //Formas de envio, consulte a documentacao
  shippingAddressStreet: 'Av. Brig. Faria Lima',
  shippingAddressNumber: '1384',
  shippingAddressComplement: '2o andar',
  shippingAddressDistrict: 'Jardim Paulistano',
  shippingAddressPostalCode: '01452002',
  shippingAddressCity: 'Sao Paulo',
  shippingAddressState: 'SP',
  shippingAddressCountry: 'BRA'}
try {
  const options = {
    method: "POST",
    url: `${}&token=${config.token}`,
    headers: {"Content-Type": url_endpoint },
    body: data,
    json: true

let result = await new Promise(function (resolve, reject) {
    request(options, function(error, response, body) {
        if (error) {
return result;
} catch (e) {


O e config.token funcionam certinho, então desconsidere.

Erro é retornado pelo BODY.

<html><head><title>JBossWeb/2.0.1.GA - Error report</title><style><!--H1 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:22px;} H2 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:16px;} H3 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:14px;} BODY {font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;} B {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;} P {font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-size:12px;}A {color : black;} {color : black;}HR {color : #525D76;}--></style> </head><body><h1>HTTP Status 404 - Could not find resource for relative : /v2/checkout/;token=7C742AD5AA394C47B39CDCC3CB40120D of full path:;token=7C742AD5AA394C47B39CDCC3CB40120D</h1><HR size="1" noshade="noshade"><p><b>type</b> Status report</p><p><b>message</b> <u>Could not find resource for relative : /v2/checkout/;token=7C742AD5AA394C47B39CDCC3CB40120D of full path:;token=7C742AD5AA394C47B39CDCC3CB40120D</u></p><p><b>description</b> <u>The requested resource (Could not find resource for relative : /v2/checkout/;token=7C742AD5AA394C47B39CDCC3CB40120D of full path:;token=7C742AD5AA394C47B39CDCC3CB40120D) is not available.</u></p><HR size="1" noshade="noshade"><h3>JBossWeb/2.0.1.GA</h3></body></html>'

Tentei até usar php mas descobri que php com nodejs não funciona.

windows – What am I doing wrong to receive Loopback and REST API WordPress Errors?

I’ve taken a dive into self hosting and learning along the way. I have a decent understanding of most of it. It only took me a day to cobble together a “working” NGINX, MySQL, PHP, phpMyAdmin and SSL. I am doing this purely for the educational purposes and fun. A playground if you will. Version information is here. SSL acquired by LetsEncrypt via certbot. The host is Windows Server 2016 Standard 10.0.14393 x64.

I’ve currently ran into a few problems.

  • WordPress Error: The REST API request failed due to an error: cURL error 28: Operation timed out after 10010 milliseconds with 0 bytes received (http_request_failed)
  • WordPress Error: The loopback request to your site failed, this means features relying on them are not currently working as expected: cURL error 28: Operation timed out after 10008 milliseconds with 0 bytes received (http_request_failed)

I have looked through some logs and can’t make heads or tails of it. I have spent a solid day trying random things I have come across. Because WordPress has zero plugins enabled or installed, and only one theme installed and used (default 2020), I am led to believe this is an issue with the server configuration. For reference, here are both the files used by NGINX:

WordPress appears to function fine. But I prefer no errors. I’m not sure where the breakdown is for this. Any help would be greatly appreciated. Thanks.

web scraping – Is there a publicly accessible API for credit card rewards data?

I’m trying to create a credit card comparison tool similar to Ratehub’s and Greedyrates’

Do major card networks like Visa, Mastercard, American Express have APIs that I can use to retrieve up-to-date data for comparison? How do the sites above get their data to compare credit cards?

sharepoint online – Power Automate Add new role definition using REST API

I’m trying to create a create role definitions i.e. custom permission level using Power Automate with below body in Send an HTTP request to SharePoint:

    'request': { '__metadata': { 'type': 'SP.RoleDefinition' }, 'BasePermissions': 
    { '__metadata': { 'type': 'SP.BasePermissions' }, 'High': '176' , 'Low': '138612801' }, 
    'Description': 'New description', 'Name': 'New role', 'Order': 180 }

Below is error:

An entry without a type name was found, but no expected type was specified. To allow entries without type information, the expected type must also be specified when the model is specified.

theming – CSS problems styling the search box block created by Search API Pages module

I’m using Search API and Search API Pages on Drupal 9 and I’m trying to style the Search API Pages search block. The problem is that when placed anywhere but bottom in the sidebar, the search block overlaps with the block below as seen in the attached pics. This makes the blocks visually too close and also (in Firefox) disables the overlapped part of the search box from being clicked in, which is really annoying. Any suggestions for resolving this?

The other issue I’m having is that the fontawesome search icon only appears within the search box in Firefox. In Chrome and Safari the icon is placed at the top left of the page, relative to the body instead of to the search block. What am I missing here?

Overlap between search block and block below

Another view of the overlap

.search-api-page-block-form-search input {
  width: 100%;
.search-api-page-block-form-search .form-item {
  width: 70%;
  float: left;
.search-api-page-block-form-search .form-actions {
  width: 30%;
  float: right;
.search-api-page-block-form-search .form-type-search input {
  border-right: none !important;
  text-indent: 25px;
  background-color: transparent;
  position: relative;
.search-api-page-block-form-search .form-type-search:before {
  content: "f002";
  font-family: FontAwesome;
  position: absolute;
  top: 25px;
  left: 35px;
  background-color: transparent;
.search-api-page-block-form-search .form-item,
.search-api-page-block-form-search .form-actions {
  margin: 5px auto!important;
  display: inline-block;
  font-family: Consolas, "courier new";
.search-api-page-block-form-search .form-actions input {
  font-family: FontAwesome;
  margin: 0 !important;

I don’t know whether I’m allowed to provide a link but you can see the problem here:
Before downvoting this please note that I’m not a coder. I’m trying my best but I’m making this up as I go along.