How to create SMART connect API

Mac · March 29, 2023, 5:39am

Hi everyone
Is there a way to create API for SMART connect so that SMART data can be shared to other applications.
Thank you

Best regards
Mac

oadolph · March 29, 2023, 10:06am

Hi Mac,
I have an yaml file describing the Rest API calls for version 7.4. I will try to get hold of the one for version 7.5.5 and provide that for you.
You can then for example call any query using the API to incorporate the data into a third party app like PowerBI

Oliver

DiegoM · March 31, 2023, 6:59pm

This could help if you are using R and the structure of the call remains in your server

github.com

dmontecino/open_SMART_Connect_data_in_R/blob/main/No_selenium_needed


library(rvest)
library(tidyverse)
library(jsonlite)
library(janitor)


#connect credentials:
username=""
password=""

#connect server url
url = ""

#open connect. The login page
session_connect = session(url)

#provide the username and password
form.unfilled = session_connect %>% html_node("form") %>% html_form()

This file has been truncated. show original

Mac · April 1, 2023, 7:27am

Hi Diego
Thank you very much for your help let me work on it

Best regards
Mac

DiegoM · April 17, 2023, 12:37am

Hi Mac,

I have organized the functions here. If you try it please let me know if it works. Thanks!