Passing Date-Picker information (startDate and endDate) as a variables in the URL to fetch filtered data from thingspeak

[Dev44]

Hi,
When I use the actual datetime values in the url, I get the expected results, but when i try to store these values in a global variable and pass those variables in the url, I am getting complete results rather than the filtered results based on the selected start and end date. Below are the url used:
https://api.thingspeak.com/channels/2505468/fields/5.json?api_key=25ZJKZEKJ2PIE89Q&start=2024-04-01%2000:00:00&end=2024-04-02%2023:59:59

https://api.thingspeak.com/channels/2505468/fields/5.json?api_key=25ZJKZEKJ2PIE89Q&start=&globalstartDate&&end=&globalendDate

I have tried multiple options like using double quotes,single quotes to pass the global variables the URL but no luck..

[Taifun]

use Do it to debug your blocks, see also tip 4 here App Inventor: How to Learn | Pura Vida Apps
see also Live Development, Testing, and Debugging Tools

It would really help if you provided a screenshot of your relevant blocks, so we can see what you are trying to do, and where the problem may be.

To get an image of your blocks, right click in the Blocks Editor and select "Download Blocks as Image". You might want to use an image editor to crop etc. if required. Then post it here in the community.

Taifun

---

Trying to push the limits! Snippets, Tutorials and Extensions from Pura Vida Apps by Taifun.

[ABG]

Here is a Thingspeak sample:

Android App to connect to Thingspeak

If that does not help,
(Canned Reply: ABG- Export & Upload .aia)
Export your .aia file and upload it here.

.

[Dev44]

.aia file for reference
SolarPower (1).aia (24.4 KB)

[ABG]

Your link2 global variable had a decent looking result when run in a browser:

{
  "channel": {
    "id": 2505468,
    "name": "SolarPower",
    "latitude": "0.0",
    "longitude": "0.0",
    "field1": "Latitude (°)",
    "field2": "Longitude (°)",
    "field3": "Date",
    "field4": "Time",
    "field5": "Power (W)",
    "field6": "Energy (kWh)",
    "created_at": "2024-04-12T10:09:41Z",
    "updated_at": "2024-04-25T10:42:51Z",
    "last_entry_id": 30
  },
  "feeds": [
    {
      "created_at": "2024-04-11T10:10:11Z",
      "entry_id": 11,
      "field5": "88"
    },
    {
      "created_at": "2024-04-12T10:10:12Z",
      "entry_id": 12,
      "field5": "88"
    }
  ]
}

When broken into parts, it contains:

So you just want to format that final text block contents from the two Date Pickers when you build the URL for Web2?

[Dev44]

Yes. I even used a textbox to display the datetime to make sure its exactly the same as used in url. But when i pass this datetime as a variable (global), i dont get the expected results. The filter conditions are not getting applied.

[ABG]

I got date filtering from Date Pickers to work.

(for a tiny bit more security)
draggable blocks:

proof:

[Dev44]

@Dev44

expected results. T

Great. It worked. Thanks for the support.