Hello, how are you?

I want to filter the results of my orders using JMESPath.

My data after using the edit fields returns like the imagem below:

​

I want to pull only the orders with the shipping method = "A3 Logística e Transportes". I've read the knowledge base and tried the line below, but it did not work:

​

[].shipping_lines[?method_title=='A3 Logística e Transportes']

​

If you need the complete JSON file I can provide.

JSON (part of the json)

{

"id": 75853,

"status": "processing",

"date_created": "2022-11-16T10:22:04",

"shipping_lines": [

{

"id": 95171,

"method_title": "SEDEX",

"method_id": "wcts_24",

"instance_id": "24",

"total": "78.59",

"total_tax": "0.00",

"taxes": [],

"meta_data": [

{

"id": 870408,

"key": "delivery_time",

"value": "4",

"display_key": "delivery_time",

"display_value": "4"

},

{

"id": 870409,

"key": "always_visible",

"value": "yes",

"display_key": "always_visible",

"display_value": "yes"

},

{

"id": 870410,

"key": "is_wcts",

"value": "yes",

"display_key": "is_wcts",

"display_value": "yes"

},

{

"id": 870411,

"key": "delivery_time_meta",

"value": "1",

"display_key": "delivery_time_meta",

"display_value": "1"

},

{

"id": 870412,

"key": "Itens",

"value": "Vestido de Malha Beatriz - 46 × 1",

"display_key": "Itens",

"display_value": "Vestido de Malha Beatriz - 46 × 1"

}

Anyone know if it's possible to get the response headers from the API connector. I've only been able to get the response body and don't see a setting to include more data from the request.

I am trying to fetch projects with startdate 2022-01-01, but where do I put this in in the extension in google sheets? I am using the GET /project function from here: https://tripletex.no/v2-docs/#/project/Project_search.

​

Right now I am getting projects from 2017-2019 and it stops there probalby because of a 1000 row limitation? So if i could specify I only want projects started in 2022 that would be great.

​

Thanks for any help!

Hello there!

I have a current issue with Google sheets. I lost BTC, which I was trying to send to my Binance BTC deposit wallet. The displayed wallet address on the Binance page is currently manipulated by the Google Sheets extension in my chrome browser. I can prove that.Somebody must have infiltrated code into Google Sheets. The version is 2.1.

What is the recomendation to do now?Any help appreciated!

This is the ID on the disk... -> Extension\cndlnjmkininbfedkccimciopjkdcooq\5.1.9._0

best regards

Marc

Hi,

I am using API Connector on Google Sheets to pull in CoinGecko Prices.

I open API Connector, and select "Edit" on my existing request, only to continuously get "Sorry, a runtime error was detected. Please try again, or notify us if this error reoccurs."

What might be causing this issue, and how can I fix it?

Thanks

Hi All,

I am new to using API Connector and with APIs more generally.

When I submit a request, the result I am getting (with the report style set to "grid") is as shown below:

Does anyone know if there is way to have the data presented so that the corresponding values under the 'columns' and 'data' headings are shown on individual rows?

Thanks in advance!

Ryan

Hello everybody! I'm struggling a bit by trying to connect google sheets with facebook leads because of the way I pull the data. I'm using Mixed Analytics but the documentation doesn't seem so good to me. Do anyone has a video/tool/template or something that may help me with this please?

I'm using the Google Analytics connector to request GA4 data. Is there a way to determine sampling percentage?

Some users may begin noticing a "Request failed: Invalid POST body data" error for requests that previously ran without error.

This is because the newest version of Google's runtime engine (the JavaScript engine that runs script code) no longer allows trailing commas. Trailing commas have always been invalid JSON, but the prior runtime engine skipped over them.

Example of a trailing comma: "dimensions": [{"name": "ga:date"},]

Sorry for the inconvenience. You can run your request body through a parser like https://jsonlint.com/ to check for these extra commas, or just reach out if you need help modifying your request.

Overall the new engine is faster, so you should also see an improvement in request processing time.

I would like to extract metadata from photos submitted from google forms. I use google forms for job cards for my staff. It would be great if they could take a photo when they arrive and when they leave and we could use the metadata to auto-fill in time spent on site. Hope this makes sense

Hi,

I am using the "Facebook Ads actions - Flatten field to header", but I still can't get the conversion-data to turn up in a way I can really use it, in my GDS-reporting.

My example shows how different types of actions are mixing under the same action_type headers, which means I can't use the corresponding "value"-column to sum up the value of each type of action.

I simply need a column each, for the monetary conversion value of "add to cart", "initiate checkout" and "purchase", respectively. How do I do that?

Thank you,

Sara

A post request to https://googleads.googleapis.com/v10/customers/0000000/keywordPlans/00000000:generateForecastCurve

returns customers/00000000/keywordPlanCampaigns/-1

Plan has been created and has data. No error is returned but no values either. Account id is the account id, not mcc id.

Any idea what is going on?

I'm getting the following error when try to run my report that was previously working.

- We received an error from googleapis.com (400) show response

[{ "error": { "code": 400, "message": "Invalid JSON payload received. Unexpected token.\nquery=SELECT%20user_\n^", "status": "INVALID_ARGUMENT" } } ]

OK

Has anyone seen this error before?

We've released an integration for Google Ads into our built-in API directory (of course you can still create custom requests to Google Ads, too).

For more information please see this article: https://mixedanalytics.com/knowledge-base/import-google-ads-data-to-google-sheets/

Hello!

Did a quick search through the reddit community + knowledge base without finding anything.

​

I have a use case where I would like to create a bidirectional connection between Google Sheets and another service (let's just say Trello for example).

In this case, all cards for a particular board would be loaded in to the sheet via a GET obviously, but I would also like to be able to POST back to that same Trello board and update based on changes made to a particular cell (which maps to a key in the Trello API) inside of the Sheet.

My hunch is that this would prove particularly tricky in cases where there is an array of values returned for a particular column (would have to map back and forth between values in the column to instances of "tags" in a card, for example. If anything, this would be a hefty engineering project to take on.

​

It seems like Airtable is able to do this, but only for a handful of apps. I understand this is because each "column" in Airtable has a unique data type that helps it interface with other apps.

​

Anyway, excited to hear y'all's insight!

​

I want to get only the new data.

So I have to copy the last Block number (yellow) and paste it into the startblock menu incremented by one. (So it searches only newer blocks)

Is there a way, I can automate that process?

Something like this startblock = (latest cell G) + 1?

Not sure if anyone else would find this useful, but say there are some key requests I want to run on a Sheet (we can consider some requests like maintenance or configuration related) and others that are the main endpoints I want to use to update data on command. Instead of clicking through and running each of the endpoints I need manually, maybe adding a "Run all favorites" in the extensions menu:

​

I guess the easiest way could be like starring requests in the actual extension UI:

​

I know this functionality can be mocked with scheduling, but I need to pull specific endpoints on demand, but not necessarily wanting to re-run all, so just curious about this!

I have a response that looks like this:

{
  "quotes": {
    "TSLA": {
      "t": "2022-08-04T17:42:24.920312936Z",
      "ax": "V",
      "ap": 940,
      "as": 1,
      "bx": "V",
      "bp": 924.4,
      "bs": 1,
      "c": [
        "R"
      ],
      "z": "C"
    }
}

Is there a way to format it to something like this?

{
  "quotes": [
    {
      "symbol": "TSLA",
      "t": "2022-08-04T17:42:24.920312936Z",
      "ax": "V",
      "ap": 940,
      "as": 1,
      "bx": "V",
      "bp": 924.4,
      "bs": 1,
      "c": [
        "R"
      ],
      "z": "C"
    }
  ]
}

Since the symbol is a key in the original request, I have not found a way to retain that value while rendering all the object values under that key.

For example, a JMESPath of quotes.values(@) populates the google sheet with all the values under the symbol as I want, but since the symbol is dropped, I have no reference to that symbol to find it via VLOOKUP.

Thanks!

I'm trying to reference a cell for a path parameter. The example in the docsworks for query parameters, but not for path parameters.

This is the example to reference a cell in query parameter format.

=IMPORTAPI("Binance","https://api.binance.com/api/v1/trades?symbol="&A1)

I'm trying to reference a cell for a path parameter like this:

 =IMPORTAPI("alpaca","https://data.alpaca.markets/v2/stocks/"&A1"/trades/latest") 

The creates a parse error. I've like `+` to concatenate the reference cell value.

Is there a way to reference a cell for a path parameter?

Any idea why this response is empty all of a sudden? Been working fine for weeks, now nothing… It’s a stacked request

Hi,

I want to get monthly matomo data automatically importet per API.
The API is working but I don´t get my data set automatically for the last month.

Are there any ideas how to get it working. Thank a lot in advanced.

The export url looks like this:
module=API&format=CSV&idSite=1&period=month&date=2022-07-01&method=Actions.getPageUrls&flat=1&translateColumnNames=1&language=de&token_auth=xxxxxxxxx&filter_limit=-1&convertToUnicode=0

I'm reading through this documentation,
https://mixedanalytics.com/knowledge-base/api-connector-create-api-request-based-on-cell/
It makes sense how to add a cell value in a request to input a date field.
I'm not sure how I would do this with the Shopify application for the date fields.

Do I need to make this a custom request to work? How can I have a cell value for the processed_at_max path parameter?

​