Timestamp Script

[SebastianCoros]

Good afternoon team,

Hope all is well. I was wondering if you have a script that would return the data from the API with the real timestamp rather than the epoch time?

Kind Regards,
Sebastian

[panickos]

Hi Sebastian,

first of all, welcome to the community! We are always happy to receive and respond to your questions.

Based on what you are asking I wrote a comprehensive guide on how to retrieve results from the API in python, using the pagination features and write them into a CSV for further processing by other tools here:

Fetching Ping Results from a Specific Agent using NetBeez API into a CSV file

In this guide, we’ll demonstrate how to write a Python script to fetch all ping results from a specific agent within a given time range, using NetBeez’s API. The results will be saved in a CSV file, with each timestamp parsed into a human-readable date/time. Prerequisites Python 3.x A valid Bearer token for NetBeez’s API Installation First, install the requests library to handle HTTP requests: pip install requests Step 1: import the necessary libraries: import requests import csv import ti…

To specifically answer your question notice the line which converts the epoch timestamp in milliseconds into a human readable timestamp here:

'ts': datetime.fromtimestamp(result['attributes']['ts'] / 1000).strftime('%Y-%m-%d %H:%M:%S'),

Let me know if you have any other questions regarding this or the API in general.

Thanks,
Panickos