Unable to retrieve data from Thingspeak API (PurpleAir)

Hello,

I am having trouble accessing the Thingspeak API with PurpleAir.

Currently my code contains this,

temp_df = pd.read_csv(StringIO(requests.get("https://api.thingspeak.com/channels/"+repr(id)+"/feeds.csv?resutls=8000&api_key="+api+"&end="+end_time).text))

where api_key is retrived from api.purpleair and end_time is for my time period.

Now it just returns -1.

This code worked before for several years however it stopped working today. I assume it blocked me out from accessing the data. How can I fix this?

[Christopher Stapels]

Are you reading multiple channels or just one channel?

[Kyongwon Yoo]

I am reading multiple channels (primary_a, primary_b, secondary_a, secondary_b)

[Kyongwon Yoo]

There was a problem on Thingspeak API, but now the problem is resolved. Thanks.

Answer 1

[Christopher Stapels]

Thank you for noting that the issue you had is resolved. If you are reading multiple channels, please be sure to use a short delay between each read attempt, so as not to create undue burden on the server.

Answer 2

[Frederic Lhoest]

Hi there,

I have the same issue; using the command line curl command on macOS it works fine.

Same thing with a php cURL function I'm receiving -1 ...

[Christopher Stapels]

Frederic, are you using exactly the smae call as the OP? Are you requesting this same query for multiple channels simultaneously or at least sequentially?

[Frederic Lhoest]

Hi Christopher,

Thanks for jumping in. I think the issue is on the way I'm using the cURL function in php, not quite sure yet... Exact same request in the command line works perfectly, but my php script is not. I still need to figure it out.

Basically what "-1" means when your get it as returned value ?

Thanks

[Christopher Stapels]

-1 genrally means unauthorized or badly formatted request.

[Frederic Lhoest]

Ok thanks !

[Frederic Lhoest]

All works ! ;)

I created a framework to assist me retrieving data : https://github.com/flhoest/ThingSpeak/blob/main/tsFramework.php

[Christopher Stapels]

Thanks for sharing! I made a small pull request to keep people who use the function in a loop from slamming the server.