When importing rich text data into a Data Warehouse (DWH), it’s often necessary to remove unwanted HTML tags while preserving essential formatting. This guide outlines a method using Python’s BeautifulSoup library to clean and structure the data efficiently. Why Strip HTML Tags? Rich text from sources like web applications, CMS platforms, and APIs often includes … Read more
Purpose The get.myhistory API and stored procedure facilitate interaction with the DataWarehouse, enabling users to retrieve historical views for analysis. Designed for PowerBI and Power Applications, it offers flexible parameters, customisable views, and outputs data in JSON format. By combining the adaptability of SQL stored procedures with a RESTful API, get.myhistory delivers a robust solution … Read more
1) What is API API stands for Application Programming Interface. That means it is an interface between two applications/computers that enables them to communicate with each other through some program. You can imagine the API as a postal pigeon delivering your request to the other side and receiving what you (hopefully) expect. In order for the … Read more
When evaluating an API for a platform, asking the right questions is critical for ensuring the platform can meet your needs. Here are some important questions to consider: 1. Authentication & Security 2. Data Access & Structure 3. Documentation & Support 4. API Rate & Limits 5. Performance & Reliability 6. Customisation & Extensibility 7. … Read more
When comparing the integration of CSV files and APIs with the DataWarehouse, several factors impact data integrity, including data accuracy, consistency, security, and the ability to handle large datasets. Below are some key comparisons and potential risks associated with each method: 1. Data Accuracy and Consistency CSV Integration: API Integration: 2. Data Security CSV Integration: … Read more
Purpose The get.myview stored procedure API allows Power Applications to interact with the DataWarehouse by performing SELECT queries on specified DataMart views. The results are returned as a JSON array. Security Parameters Required Optional Typical Use URL HTTP Header: cURL Example: PowerBI: PowerShell
https://greencoatrenewables.greenbyte.cloud/Monitor/Portfolio https://lucid.helastel.com/datasheet/view/securedata/detail?id=4907 https://greencoatukwind.greenbyte.cloud/Monitor/Portfolio https://lucid.helastel.com/datasheet/view/securedata/detail?id=3867
https://developer.greenbyte.com/v/2_2-beta#/http/how-to-get-started
From blank Query With Parameters with variable dates (and PageNo) On the subject of page numbers if you do not know how many pages to list … try this… Set the above query to a function that will accept a page number … fRunn_actuals = Testing the invoke should allow you to enter a page … Read more
You can install an authenticator app on your laptop or desktop computer. If you can’t install apps on your work computer yourself, ask your IT team to install an authenticator app for you, either on your computer or your organisation’s server. There are various authenticator apps available, such as our recommended app Authy. If you want … Read more