See here: socrata/discuss#30

Things to do:

• Drop support for 5.3, 5.4, 5.5; make use of 5.6 only features such as array
• Remove unit testing for unsupported PHP versions
• Update PHPUnit in composer.json

• API limits have been removed as of 2.1 datasets
• Throw a warning/exception when a number greater than 50,000 is used on older datasets

Hi,
I want to use the PHP PhpSoda library in my own project how can i add SodaClient in my index.php file

When i add "use allejo\Socrata\SodaClient;" and i instantiate $sc = new SodaClient("http://opendata.socrata.com"); it's give me the error ( ! ) Fatal error: Class 'allejo\Socrata\SodaClient' not found in C:\wamp\www\Socrata\PhpSoda\tests\index.php on line 6
Call Stack

Time Memory Function Location

1 0.0010 131408 {main}( ) ..\index.php:0
how can i resolve it please?

In original documentation , Select query with aliases is given the following explanation:
https://github.com/allejo/PhpSoda/wiki/Working-with-SoQL-Queries

I came across two issues while working with aliases:

1. When a select is given with alias, the $select statement generated has white spaces instead of %20. As a result, the HTTP request fails with response of 400 error code

eg: $selectWithAliases = array(
"origin" => "origin_type"
);

URL formed: https://.../.../...?$select=origin AS origin
Expected URL: https://.../.../...?$select=origin%20AS%20origin

2. While trying the case "Not all column names must have an alias", the column given without alias are generated like origin AS , file_type AS, year as publication_year instead of origin, file_type, year as publication_year

eg: $selectWithAliases = array(
"origin",
"file_type",
"year" => "publication_year"
);

URL formed: https://.../.../...?$select=origin AS ,file_type AS ,year AS publication_year
Expected URL: https://.../.../...?$select=origin,filer_name,year AS publication_year

A patch is required in line 169 of src/SoqlQuery.php to fix these 2 issues:

$formattedValues[] = (is_string($key) && (!is_null($value))) ? rawurlencode(sprintf($format, trim($key), trim($value))) : (is_string($key) ? $key : $value);

(is_string($key) && (!is_null($value))) ? rawurlencode(sprintf($format, trim($key), trim($value))) : (is_string($key) ? $key : $value) will handle the following cases:

1. Select with key and value ( column with alias )
2. Select with key and null value( column without alias while other column may come with alias)
3. Select with value ( column without alias in any column of select statement)

Write operations to Socrata datasets with the Socrata Open Data API differ from write operations with the more recent Data Management API. Specifying which API this library uses helps prevent user confusion.

Adding something like:

Note: This library supports writing directly to datasets with the Socrata Open Data API. For datasets with one or more data transformations applied to the schema through the Socrata Data Management Experience (the user interface for creating datasets), use the Socrata Data Management API to apply those same transformations to all updates. For more details on when to use SODA vs the Socrata Data Management API, see the Data Management API documentation

to the readme and wiki would help clarify expectations when publishing to Socrata.

I'll open a PR with changes.

Should the check have a ! in it?

The following gets passed into $response which does not json_decode and falls into the if block.

HTTP/1.1 100 Continue

HTTP/1.1 400 Bad Request
Server: nginx
Date: Mon, 24 Jun 2019 20:00:04 GMT
Content-Type: application/json; charset=utf-8
Transfer-Encoding: chunked
Connection: keep-alive
X-Socrata-RequestId: 316xuzmsevgwlsbdhjwwokmpw
Access-Control-Allow-Origin: *
X-Error-Code: invalid_request
X-Error-Message: Illegal field name sent: contractor_nid
Cache-Control: private, no-cache, must-revalidate
Age: 0
X-Socrata-Region: aws-us-east-1-fedramp-prod

{
  "code" : "invalid_request",
  "error" : true,
  "message" : "Illegal field name sent: contractor_nid"
}

Reflect these changes: https://dev.socrata.com/changelog/2015/11/25/soda-api-versioning.html