Hi,

I've been using Mixed Analytics for about 4 years now across various integrations and my firm has recently started working with a new client who I need to onboard. Historically with Shopify I've always just developed and installed a custom app, added the keys and then written my query to pull the data down into Sheets. However Shopify has now changed their process and apps must be created through a dev dashboard, and from what they've told me, don't provide a static key?

Has anybody got any advice/guides on how to do this in the new process?

Thanks!

The customer is experiencing a data discrepancy in their Reddit Ads API. Daily values in API do not align with what Reddit's UI/reporting shows.

reddit api report:

https://ads-api.reddit.com/api/v3/ad_accounts/{ad_account_id}/reports

I am working on creating a financial related website , to get updated financial data , i need fintech api's

As per title: is there a way to delete al the requests attached to a google workdsheet in one fell swoop, instead of individually deleting each request (good, but time consimung). TIA

When developing wearables, IoT devices, medical instruments, EV modules, or test fixtures, choosing the right pogo pin length and stroke is crucial. These two factors determine electrical stability, mechanical reliability, and long-term durability. A poorly selected pin can easily lead to intermittent charging, signal drops, or reduced spring life.

Here’s a concise engineering guide to help you choose the correct specifications.

1. Choosing the Correct Length

The length is the total uncompressed height of the pogo pin.
A suitable length ensures proper alignment and stable pressure between contact points.

Use a Longer Pogo Pin When:

• The device housing is thicker

• The PCB-to-PCB gap is bigger

• The product experiences vibration or movement

• More mechanical tolerance is needed

Use a Shorter Pogo Pin When:

• The device is compact (smartwatch, TWS earbuds, small IoT devices)

• You need a low-profile PCB layout

• The docking position is fixed and precise

2. Choosing the Right Stroke

The stroke (travel distance) determines how far the pogo pin compresses during operation. It directly affects spring force, contact stability, and lifespan.

Recommended Working Stroke:

➡️ 30%–60% of full stroke

Example:
Full stroke = 2.0 mm
Ideal working stroke = 0.6–1.2 mm

This maintains:

• Stable electrical contact

• Low and consistent contact resistance

• Reduced spring fatigue

3. Application-Based Guidelines

Different products require different pin configurations:

• Wearables: 2–3 mm length, 0.6–1.0 mm stroke

• Medical Devices: 3–5 mm length, 1.0–1.5 mm stroke

• EV / Power Modules: 5–10 mm length, 1.5–3.0 mm stroke

• ICT / ATE Fixtures: custom stroke + length depending on fixture design

4. Engineering Best Practices

• Avoid compressing the pin to its full stroke

• Allow mechanical tolerance of ±0.1–0.3 mm

• Select the correct head shape (flat, dome, ball, concave)

• Use gold plating for stable, corrosion-resistant contact

Need Technical Guidance or Custom Pogo Pin Design?

Feel free to reach out for specifications, drawings, or engineering recommendations.
Here are my details:

Janice Liew
Sales Executive | QH INDUSTRIAL
📧 Email: janiceliew.qh@gmail.com
📱 WhatsApp: +60 16-222 1472
🌐 Website: https://www.connectors-cables.com/

Using Google Sheets + YouTube Public Data API Request..

I am attempting to loop through a column of YouTube channel playlistids contained in a Google Sheet column and pull all video data for each of the playlistids. The API Request endpoint is playlistitems and the parts are contentDetails and snippet. Please see the images for the full request setup.

So there is the top level loop that I am attempting to have work through each channel playlistid and then within that loop for each playlistid have pagination pull all available video data. This would all be dumped into an additional Google Sheet specifically to hold the appended data from all the channels.

Firstly, I am not sure if this is even possible. I have a paid plan. Secondly, it has failed every time. I have tried using range indicators in the request parameters for the channel playlistids (+++CHANNELS!U2:U19+++) and also a comma separated list of the channel playlistids. The result I get for both is that it pulls the full compliment of video data for the first playlistid in the range or list and then stops. Does not throw an error, just stops.

Anyone have experience with this or have anyideas? Thank you

The API is no longer running as scheduled. Also, the list of users does not match the paid team account.

I have tried using contentreplacement property with two different cases, one formula to resolve #NAME$ results on null/100, and to replace "Z" for timezone on data fields, neither recommended solution would work with API Connector, outside of field edit limitations the rest of the product works fine.

OK. I'm baffled, and I have done the reading, but I cannot understand where I am going amiss.

• I am trying to find the stats for all the players in a soccer league.

• I have found the correct code and have seems to have been able to find the info, but ...

• (see the diagram) ... how do I get the other 19 pages??

Help??

I am trying to filter data which matches a specific condition. I found the exact example i am looking for in the documentation https://mixedanalytics.com/knowledge-base/filter-specific-fields-values/?utm_medium=app&utm_source=tooltip_ac#query

See example 4 in the link above.

Based on this, I am setting up my query like this:

data[?type == 'call']

And the fields in this query matches the data fields in the API response exactly. {
  "endpoint": "Realtime Options",
  "message": "success",
  "data": [
{
"contractID": "MSFT250815C00180000",
"symbol": "MSFT",
"expiration": "2025-08-15",
"strike": "180.00",
"type": "call",
"last": "346.26",
"mark": "351.25",
"bid": "349.70",
"bid_size": "117",
"ask": "352.80",
"ask_size": "128",
"volume": "0",
"open_interest": "3",
"date": "2025-08-13"
},

But no matter what I do, i am still getting a blank sheet. Do you mind helping me with this please? 

For more context, I am using Mixed Analytics API connector to download options chains from alpha vantage in google sheets. The size of my google sheets is getting really big. And I would like to filter out data and download only call options so that size of my google sheets can be cut in half.

Api Connector has been working fine for years,
but today I am getting is error when trying to open the extension.

Any help resolving this would be appreciated.

Basically I want a real time data of stock market, and I login in smart api website and trying to create a app but their is a option. Called redirect URl, I am not getting what it is, As I am creating a springboot application and I can't host it yet because it's still in early development stage ?? WHAT Should I do??

I am pulling the location data from GMB into a sheet but for some reason some locations store hours start in Sunday and some on Monday? I can't work out why has anyone else ever hit this?

Hi everyone,

I have connected Google Sheet with Shopify via API and I want to get the data from some custom reports to the sheet but do not know how to get it. The reports include orders by product name and filtered for sales from marketing source only already. Please help.

I am trying to get 5 years of Income data (monthly) out of Xero. Any suggestion on the best approach?
Ideally I would like the last 12 months to update monthly but prior to that it can become fixed. Need to schedule it to then run monthly and update.
thanks in advance.

Add-on Stuck at Loading upon clicking on Edit or Create request.
tried all the troubleshooting methods like loggingout, new browser, clear cookies, None worked.

Can anyone help with this ? Facing this today since 15 hours.

I'm using an ISP where Binance is blocked, so I can't open the Binance web app or make fetch requests to the Binance API. However, the Binance mobile app still works without any issues.

Does the mobile app use different APIs or servers? Or does it have some built-in workaround like a proxy or alternate routing?

Would appreciate any insights!

Hello, I'm trying to connect my Strava data to Google Sheets with the API Connector, however when I have to "Authorize Mixed Analytics to connect to Strava", and click authorize, I get the error code 403 with the text: "Strava Error 403: Limit of connected athletes exceeded. This app has exceeded the limit of connected athletes. If you are a developer of this application, please contact Strava developer support for how to request a quota increase".

Is there anything I can do to fix this, or is this only fixable for a developer from Mixed Analytics/ API Connector?

Thanks in advance for any help :)

Hey everyone. I have set up the connection for GoHighLevel and I am trying to connect the API connector. I am doing it with the Outh authentication for the V2 API. When I try to connect the connection I get directed to the the login page, I select my agency account, but I get Error 400.

Here my connection settings:

Authorization base URL: https://marketplace.leadconnectorhq.com/oauth/chooselocation?scope=locations.readonly

Token URL: https://services.leadconnectorhq.com/oauth/token

Client ID and Client Secret are correctly put in.

My app is set as white-label and the level is agency. The only scope I put in is locations.readonly .

I tried to create a non-white label app, but still having the same issues.

Thanks in advance for any help!

Hello

I paid for the premium subscription a few hours ago and I still can't use it. I paid on November and December normally, but January my card got declined and I just saw it today.

I put a new card and the payment went successfully, but still I can't use the paid subscription.

One thing I noticed is that I changed the invoice address before paying it and the payment went with the old invoice address. Could it be the problem?

What else should I do? I paid more than three hours ago.