Skip to content

Instantly share code, notes, and snippets.

@mnapoli
Created April 10, 2019 17:23
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mnapoli/b30a2218ce45ab78ecde33939adb4f86 to your computer and use it in GitHub Desktop.
Save mnapoli/b30a2218ce45ab78ecde33939adb4f86 to your computer and use it in GitHub Desktop.

Before (from here):

After:

{
    "sqlStatementResults": [
        {
            "numberOfRecordsUpdated": -1,
            "resultFrame": {
                "records": [
                    {
                        "values": [
                            {
                                "intValue": 1
                            },
                            {
                                "stringValue": "Category 1"
                            }
                        ]
                    },
                    {
                        "values": [
                            {
                                "intValue": 2
                            },
                            {
                                "stringValue": "Category 2"
                            }
                        ]
                    },
                    {
                        "values": [
                            {
                                "intValue": 3
                            },
                            {
                                "stringValue": "Category 3"
                            }
                        ]
                    },
                    {
                        "values": [
                            {
                                "intValue": 4
                            },
                            {
                                "stringValue": "Category 4"
                            }
                        ]
                    },
                    {
                        "values": [
                            {
                                "intValue": 5
                            },
                            {
                                "stringValue": "Category 5"
                            }
                        ]
                    }
                ],
                "resultSetMetadata": {
                    "columnCount": 2,
                    "columnMetadata": [
                        {
                            "arrayBaseColumnType": 0,
                            "isAutoIncrement": false,
                            "isCaseSensitive": false,
                            "isCurrency": false,
                            "isSigned": true,
                            "label": "id",
                            "name": "id",
                            "nullable": 1,
                            "precision": 11,
                            "scale": 0,
                            "schemaName": "",
                            "tableName": "categories",
                            "type": 4,
                            "typeName": "INT"
                        },
                        {
                            "arrayBaseColumnType": 0,
                            "isAutoIncrement": false,
                            "isCaseSensitive": false,
                            "isCurrency": false,
                            "isSigned": false,
                            "label": "name",
                            "name": "name",
                            "nullable": 1,
                            "precision": 255,
                            "scale": 0,
                            "schemaName": "",
                            "tableName": "categories",
                            "type": 12,
                            "typeName": "VARCHAR"
                        }
                    ]
                }
            }
        }
    ]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment