g3n1us/datatidy

Get data from Google Sheets or other sources, and return standardized, structured, tidy data

Sunday, August 20, 2017
by g3n1us
Repository
1 Watchers
0 Stars
40 Installations

PHP
1 Dependents
0 Suggesters
0 Forks
0 Open issues
6 Versions
0 % Grown

The README.md

datatidy

Get data from Google Sheets and other sources, and return standardized, structured, tidy data, _(*1)

Usage

Options

$defaultoptions = [
    'allow_origin' => null, // If a response is to be generated, this value will be applied to an Access-Control-Allow-Origin header
    'resultsas' => 'collection', // or paginate or array
    'sort' => false, // key by which to sort
    'ascending' => false, // applies to the sort order
    'nomd' => false, // my default, content will be converted to HTML with Markdown, this option disables this
    'paginate' => false,
    'show_pagination' => true,
    'results_per_page' => 12,
];

Arguments

URI or path to retrieve data.

To retrieve a Google Sheets spreadsheet, use the format: gproxy://<spreadsheet-key>, _(*2)

NOTE: The spreadsheet must be published publicly!, _(*3)

For other JSON formatted URIs, specify either a relative or absolute endpoint to retrieve, _(*4)

OPTIONS: An array of options as shown above

Call via static methods

DataTidy::response("gproxy://1R4ZW6fw7EggY6AsmBtVGWdjny-UYDgv3au6_VarHBMk", ['allow_origin' => '*']);
// Returns a full Response

DataTidy::get("gproxy://1R4ZW6fw7EggY6AsmBtVGWdjny-UYDgv3au6_VarHBMk");
// Returns the data as an instance of Illuminate\Collection

Call via constructor

use G3n1us\DataTidy;

$datatidy = new Datatidy("gproxy://1R4ZW6fw7EggY6AsmBtVGWdjny-UYDgv3au6_VarHBMk");
$datatidy->get();
// or
$datatidy->response();