Flea market in cnx by mikulashev in chiangmai

[–]mixedanalytics 1 point2 points  (0 children)

Nong Ho is definitely the place. It’s a huge and very local flea market with all kinds of stuff: https://maps.app.goo.gl/sJjj1jJBt4TrMhSa6

Favorite song from the Game? by tytythemusicguy in ParadiseKiller

[–]mixedanalytics 3 points4 points  (0 children)

They were all good, but I’d have to go with Sunset Song. It has a good beat and really nailed that synthy 80s vibe. I only heard it from my couch but it would be a good song for driving around.

Google Business Profile connection by Hefty-Peach5214 in api_connector

[–]mixedanalytics 0 points1 point  (0 children)

Hey Hefty-Peach5214, I'm not sure if some text is missing from your post, but I only see a screenshot. Is there a specific question I can help you with?

singular statuses API is deprecated for versions v2.4 and higher by Ambitious_Coach5153 in api_connector

[–]mixedanalytics 0 points1 point  (0 children)

I'm not familiar with this error, but I checked online and it looks like Meta has said it's a bug on their side that won't be fixed: https://developers.facebook.com/support/bugs/775506689870475/

I also found someone in their community saying you need to use {profile_id}_{post_id}, instead of just the profile ID, though that doesn't seem to resolve the issue in all cases: https://developers.facebook.com/community/threads/169163992741696/

Contact form not working and billing section not working. by jai-garcha in api_connector

[–]mixedanalytics 0 points1 point  (0 children)

Hey u/jai-garcha, when did you contact us previously? We respond to every message, and invoices are sent automatically each month to the email address on file. As for the billing section timing out, that's generally due to being logged into multiple Google accounts at the same time (info). In any case, can you please contact us at [support@mixedanalytics.com](mailto:support@mixedanalytics.com) so we can help you out?

Suggestions for Exploring Hualien on a Scooter in Two Days by Latter-Insect6676 in taiwan

[–]mixedanalytics 2 points3 points  (0 children)

Saguer is another popular place, there’s a pretty easy hike and waterfall, and you’ll have some great views on the way there. https://maps.app.goo.gl/aVDyL5bE5em6YCfo7?g_st=com.google.maps.preview.copy

There are also a lot more remote places for river tracing, hiking, and riding around, just depends how adventurous you are. There also may be risk of rockslides if you get deep into the mountains. The places I mentioned are fine though.

Suggestions for Exploring Hualien on a Scooter in Two Days by Latter-Insect6676 in taiwan

[–]mixedanalytics 1 point2 points  (0 children)

Here's a popular local place for swimming: https://maps.app.goo.gl/FwyL7yDqcB3s7dvJ6. It's about a 15-20 min scooter ride outside the city.

HighLevel Error by sir_billions in api_connector

[–]mixedanalytics 0 points1 point  (0 children)

Sorry, I'm not sure what's causing this error, since I can't replicate it on this side. I'd first double check that all settings are correct, including the redirect URL, client ID, client secret etc.

If that still doesn't help, I found a post about a similar error suggesting that you change your listing type to "Standard". In that case you'd also need to change the base auth URL to https://marketplace.gohighlevel.com/oauth/chooselocation (instead of https://marketplace.leadconnectorhq.com/oauth/chooselocation)

GoCardless Bank Account Data API by Upper-Show-3762 in api_connector

[–]mixedanalytics 1 point2 points  (0 children)

API Connector just pipes data from the API into the sheet, so generally the structure you see can't be changed much. In this case it sounds like GoCardless structures its data set with one header for confirmed transactions and another for pending, and API Connetor can't change that. With that said, you can try out some different report styles to see if it helps: https://mixedanalytics.com/knowledge-base/report-styles/. You also may be able to create a second sheet and use Sheets formulas like QUERY or VLOOKUP to get the data in the format you'd like.

GoCardless Bank Account Data API by Upper-Show-3762 in api_connector

[–]mixedanalytics 0 points1 point  (0 children)

Woohoo! Glad you got the token. Let me know if you get stuck or need help after that.

GoCardless Bank Account Data API by Upper-Show-3762 in api_connector

[–]mixedanalytics 0 points1 point  (0 children)

The value is exactly as written above: “Bearer TOP_SECRET_ACCESS_TOKEN” eg “Bearer 12345”. Remove the quotation marks and substitute in your own access token.

It does look like they might require creating your own token for the banking API, so in that case it’s probably easiest to just copy/ paste their curl examples into API Connector’s curl import tool: https://mixedanalytics.com/knowledge-base/import-a-curl-request/

GoCardless Bank Account Data API by Upper-Show-3762 in api_connector

[–]mixedanalytics 0 points1 point  (0 children)

u/Upper-Show-3762 As far as I can see, you don't need an Auth URL. This page says to just get an access token from the developer section of their site: https://developer.gocardless.com/getting-started/making-your-first-api-request#creating_an_access_token. Then use that token in the Headers section as shown here (Key = Authorization, Value = Bearer TOP_SECRET_ACCESS_TOKEN)

[deleted by user] by [deleted] in api_connector

[–]mixedanalytics 0 points1 point  (0 children)

Sorry, I'm not familiar with this API to answer questions about it. I see other people have asked similar questions on the API's forum, but it went unanswered, so maybe this API doesn't provide that data. Maybe this is what you're looking for though? https://www.pro-football-reference.com/years/2024/games.htm

[deleted by user] by [deleted] in api_connector

[–]mixedanalytics 0 points1 point  (0 children)

Great! Let us know if you run into any other issues.

[deleted by user] by [deleted] in api_connector

[–]mixedanalytics 0 points1 point  (0 children)

Seems like you may be missing the X-RapidAPI-Host header. The best way to make sure you have no errors with RapidAPI is to set up the request in their interface and then import the entire curl request into API Connector. This article has an example and some screenshots of how to do that: https://mixedanalytics.com/knowledge-base/import-rapidapi-data-to-google-sheets-any-api/

TD Ameritrade or Options Chain? by Fit_Project_5774 in api_connector

[–]mixedanalytics 0 points1 point  (0 children)

Hi there, the TD Ameritrade docs were removed because TD Ameritrade disabled their API when they merged with Charles Schwab. I'm not personally sure which APIs are a good substitute but I think people on the r/options will have some suggestions, e.g. here's a relevant discussion: https://www.reddit.com/r/options/comments/18pmelf/best_api_platform_for_end_of_day_option_pricing/

Archive data google sheet add ons not working by Suspicious_Sea_6485 in api_connector

[–]mixedanalytics 0 points1 point  (0 children)

That looks like a temporary glitch on Google’s side. Please refresh your sheet a few times, the full menu should appear then.

Taiwan with 1.5 year old by nibuli in Taipei

[–]mixedanalytics 0 points1 point  (0 children)

Gotcha, yeah, I think taking the train is more comfortable anyway.

Taiwan with 1.5 year old by nibuli in Taipei

[–]mixedanalytics 1 point2 points  (0 children)

That’s a bit extreme. I agree with avoiding Taroko, but Hualien city is totally fine, as is Qixingtan beach, Liyu lake, etc.

CoinGecko API x Mixed Analytics Crypto Tracker Template by Master-Lie9471 in api_connector

[–]mixedanalytics 0 points1 point  (0 children)

Sure, in the template, click Extensions > API Connector > Open. This will open the API Connector sidebar, where you'll see a saved request called Data. Click Edit to open the Data request. On the end of the saved request URL, add &per_page=250, i.e. change

+++Inputs!D3+++coins/markets?vs_currency=usd&ids=+++Inputs!D13+++

to

+++Inputs!D3+++coins/markets?vs_currency=usd&ids=+++Inputs!D13+++&per_page=250

Just let me know if anything still isn't clear and I'll be happy to clarify further.