Flexio Data Interaction

Interaction with the Flexio API

getFlexioResource()

Returns a dataset containing resources records from Flexio

postFlexioResource()

Sends a resource to Flexio. Adds each entry of the given dataset to the Flexio resource, Returns the a vector with the recordIDs

getFlexioRecord()

Returns a 1 entry dataset containing a single resource record from Flexio

putFlexioRecord()

Updates a resource record from Flexio (all the fields)

patchFlexioRecord()

Updates a resource record from Flexio (only the given fields)

deleteFlexioRecord()

Deletes a resource record from Flexio

getFlexioResourceFieldsTypes()

Returns a list containing the Flexio resource fields names and their types

getFlexioResourceSchema()

Returns the raw schema of a flexio resource

downloadFlexioFile()

Download the file which is in the given Flexio record and stores it in the target file

Flexio Connector Interaction

returnValues()

Writes a list as JSON to a file If run inside Flexio, the data written in the file will then be used to by the connector

Data formatting

setFieldNames()

Replaces the fields names with the given ones

castStringToNum()

Convert a dataset's columns from string to numeric

castDATETIMEToTime()

Convert a dataset's columns from DATETIME string format to numeric

castDATEToTime()

Convert a dataset's columns from DATE string format to numeric

castTIMEToTime()

Converts a dataset's columns from TIME string format to numeric

Others

saveDatasetToFile()

Saves a dataset in a .csv file

downloadFlexioFile()

Download the file which is in the given Flexio record and stores it in the target file