Json¶

sUrl¶

The URL to retrieve the JSON from (could also be a local file).

bUrlEncode¶

Boolean. If set to true, PHP's urlencode(...) is applied to the URL.

sRootNode¶

The node (or path to the node, respectively) under which to find the single elements. Could e.g. be

data/results

Do not use a trailing slash.

sTimestampOnAdd¶

If set and not empty, everytime a new entry is created the current unix timestamp is written to this field. Quite common in TYPO3 table is the column name crdate, altough it's, of course, not obligatory.

sTimestampOnEdit¶

Basically the same as sTimestampOnAdd but for editing. So everytime an entry is updated, the current unix timestamp is written to this field. Common in TYPO3: tstamp

Deletion and marking deleted¶

If you delete something from a database table, it is deleted. Removed. Gone. Unless you don't really delete it but instead mark it being deleted. This is, what a lot of applications (within TYPO3) do in order to be e.g. capable of providing a recycler. Entries are only marked deleted when users delete them and thus not shown anymore, but in the database they still persist and can be restored.

For this to be achieved in a SQL Frontend, you may use the following settings telling the system which column is the one to carry the marks and what values it expects for both, entries that are deleted (sDeletedTrue) and entries that aren't (sDeletedFalse).

Default values (except bSetDeleteFieldInsteadOfDeletion) represent default TYPO3 configuration. Thus, if you are displaying any TYPO3 table and want to use this feature, most likely you just need to set bSetDeleteFieldInsteadOfDeletion to true.