#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2013
    Posts
    29
    Rep Power
    0

    Caunter in array


    Hi to all javascript maniacs.
    I have a huge JSON fail and from him i have to look for few parameters. When it faund it all of them, have to write the numbers in table.Code below is 15 % of all code.


    {
    "dataset": [
    {
    "schema" : {
    "manifest":{
    "datasetname": "TBL.SecurityUsers",
    "schemaformat": "JSON",
    "dataformat": "JSON",
    "encoding": "utf-8",
    "security": {},
    "cacheable": {}
    },
    "parameters":[
    ],
    "columns":[
    { "name": "SecurityObjectTypeID",
    "heading": "SecurityObjectTypeID",
    "headingglobalizationenabled": "True",
    "sqlparamname": "",
    "datatype": "char",
    "datatypecharlength": "1",
    "datatypenumericprecision": "",
    "datatypenumericprecisionradix": "",
    "datatypenumericscale": "",
    "datatypedatetimeprecision": "",
    "allownulls": "False",
    "defaultvalue": "(\\U\\)",
    "lookup": {},
    "controlvisual": {},
    "validator": {},
    "ordinalposition": "1"
    }
    , { "name": "SecurityObjectUserID",
    "heading": "SecurityObjectUserID",
    "headingglobalizationenabled": "True",
    "sqlparamname": "",
    "datatype": "bigint",
    "datatypecharlength": "",
    "datatypenumericprecision": "19",
    "datatypenumericprecisionradix": "10",
    "datatypenumericscale": "0",
    "datatypedatetimeprecision": "",
    "allownulls": "False",
    "defaultvalue": "",
    "lookup": {},
    "controlvisual": {},
    "validator": {},
    "ordinalposition": "2"
    }
  2. #2
  3. A Not To Shabby Code Smurf
    Devshed Beginner (1000 - 1499 posts)

    Join Date
    Aug 2008
    Posts
    1,123
    Rep Power
    119
    Originally Posted by val10
    Hi to all javascript maniacs.
    I have a huge JSON fail and from him i have to look for few parameters. When it faund it all of them, have to write the numbers in table.Code below is 15 % of all code.
    Sorry, lost in translation... can you try to explain a little more in detail? Seems like your wanting to look for a specific value, in a JSON variable's key and if it appears (in that variable's key); then you want to update some number in a table. Is this a somewhat correct conception, of what you are wanting to do?

    As..., for this...
    Originally Posted by val10
    Code below is 15 % of all code.
    I am clueless, to what you mean.
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2013
    Posts
    29
    Rep Power
    0
    Yes i have this JSON file. Look it here:


    I have to caunt how many parameters and rows and nvarchar is in it.
    And write the values in table.




    {
    "dataset": [
    {
    "schema" : {
    "manifest":{
    "datasetname": "TBL.SecurityUsers",
    "schemaformat": "JSON",
    "dataformat": "JSON",
    "encoding": "utf-8",
    "security": {},
    "cacheable": {}
    },
    "parameters":[
    ],
    "columns":[
    { "name": "SecurityObjectTypeID",
    "heading": "SecurityObjectTypeID",
    "headingglobalizationenabled": "True",
    "sqlparamname": "",
    "datatype": "char",
    "datatypecharlength": "1",
    "datatypenumericprecision": "",
    "datatypenumericprecisionradix": "",
    "datatypenumericscale": "",
    "datatypedatetimeprecision": "",
    "allownulls": "False",
    "defaultvalue": "(\\U\\)",
    "lookup": {},
    "controlvisual": {},
    "validator": {},
    "ordinalposition": "1"
    }
    , { "name": "SecurityObjectUserID",
    "heading": "SecurityObjectUserID",
    "headingglobalizationenabled": "True",
    "sqlparamname": "",
    "datatype": "bigint",
    "datatypecharlength": "",
    "datatypenumericprecision": "19",
    "datatypenumericprecisionradix": "10",
    "datatypenumericscale": "0",
    "datatypedatetimeprecision": "",
    "allownulls": "False",
    "defaultvalue": "",
    "lookup": {},
    "controlvisual": {},
    "validator": {},
    "ordinalposition": "2"
    }
    , { "name": "Login",
    "heading": "Login",
    "headingglobalizationenabled": "True",
    "sqlparamname": "",
    "datatype": "nvarchar",
    "datatypecharlength": "128",
    "datatypenumericprecision": "",
    "datatypenumericprecisionradix": "",
    "datatypenumericscale": "",
    "datatypedatetimeprecision": "",
    "allownulls": "False",
    "defaultvalue": "",
    "lookup": {},
    "controlvisual": {},
    "validator": {},
    "ordinalposition": "3"
    }
    , { "name": "Password",
    "heading": "Password",
    "headingglobalizationenabled": "True",
    "sqlparamname": "",
    "datatype": "nvarchar",
    "datatypecharlength": "128",
    "datatypenumericprecision": "",
    "datatypenumericprecisionradix": "",
    "datatypenumericscale": "",
    "datatypedatetimeprecision": "",
    "allownulls": "False",
    "defaultvalue": "",
    "lookup": {},
    "controlvisual": {},
    "validator": {},
    "ordinalposition": "4"
    }
    , { "name": "FirstName",
    "heading": "FirstName",
    "headingglobalizationenabled": "True",
    "sqlparamname": "",
    "datatype": "nvarchar",
    "datatypecharlength": "128",
    "datatypenumericprecision": "",
    "datatypenumericprecisionradix": "",
    "datatypenumericscale": "",
    "datatypedatetimeprecision": "",
    "allownulls": "False",
    "defaultvalue": "(\\\\)",
    "lookup": {},
    "controlvisual": {},
    "validator": {},
    "ordinalposition": "5"
    }
    , { "name": "LastName",
    "heading": "LastName",
    "headingglobalizationenabled": "True",
    "sqlparamname": "",
    "datatype": "nvarchar",
    "datatypecharlength": "128",
    "datatypenumericprecision": "",
    "datatypenumericprecisionradix": "",
    "datatypenumericscale": "",
    "datatypedatetimeprecision": "",
    "allownulls": "False",
    "defaultvalue": "(\\\\)",
    "lookup": {},
    "controlvisual": {},
    "validator": {},
    "ordinalposition": "6"
    }
    , { "name": "CompanyName",
    "heading": "CompanyName",
    "headingglobalizationenabled": "True",
    "sqlparamname": "",
    "datatype": "nvarchar",
    "datatypecharlength": "128",
    "datatypenumericprecision": "",
    "datatypenumericprecisionradix": "",
    "datatypenumericscale": "",
    "datatypedatetimeprecision": "",
    "allownulls": "False",
    "defaultvalue": "(\\\\)",
    "lookup": {},
    "controlvisual": {},
    "validator": {},
    "ordinalposition": "7"
    }
    , { "name": "BadLoginAttempts",
    "heading": "BadLoginAttempts",
    "headingglobalizationenabled": "True",
    "sqlparamname": "",
    "datatype": "tinyint",
    "datatypecharlength": "",
    "datatypenumericprecision": "3",
    "datatypenumericprecisionradix": "10",
    "datatypenumericscale": "0",
    "datatypedatetimeprecision": "",
    "allownulls": "False",
    "defaultvalue": "(0)",
    "lookup": {},
    "controlvisual": {},
    "validator": {},
    "ordinalposition": "8"
    }
    , { "name": "DOB",
    "heading": "DOB",
    "headingglobalizationenabled": "True",
    "sqlparamname": "",
    "datatype": "varchar",
    "datatypecharlength": "31",
    "datatypenumericprecision": "",
    "datatypenumericprecisionradix": "",
    "datatypenumericscale": "",
    "datatypedatetimeprecision": "",
    "allownulls": "False",
    "defaultvalue": "(\\\\)",
    "lookup": {},
    "controlvisual": {},
    "validator": {},
    "ordinalposition": "9"
    }
    , { "name": "Gender",
    "heading": "Gender",
    "headingglobalizationenabled": "True",
    "sqlparamname": "",
    "datatype": "char",
    "datatypecharlength": "1",
    "datatypenumericprecision": "",
    "datatypenumericprecisionradix": "",
    "datatypenumericscale": "",
    "datatypedatetimeprecision": "",
    "allownulls": "False",
    "defaultvalue": "(\\M\\)",
    "lookup": {},
    "controlvisual": {},
    "validator": {},
    "ordinalposition": "10"
    }
    , { "name": "Address1",
    "heading": "Address1",
    "headingglobalizationenabled": "True",
    "sqlparamname": "",
    "datatype": "nvarchar",
    "datatypecharlength": "255",
    "datatypenumericprecision": "",
    "datatypenumericprecisionradix": "",
    "datatypenumericscale": "",
    "datatypedatetimeprecision": "",
    "allownulls": "False",
    "defaultvalue": "(\\\\)",
    "lookup": {},
    "controlvisual": {},
    "validator": {},
    "ordinalposition": "11"
    }
    , { "name": "Address2",
    "heading": "Address2",
    "headingglobalizationenabled": "True",
    "sqlparamname": "",
    "datatype": "nvarchar",
    "datatypecharlength": "127",
    "datatypenumericprecision": "",
    "datatypenumericprecisionradix": "",
    "datatypenumericscale": "",
    "datatypedatetimeprecision": "",
    "allownulls": "False",
    "defaultvalue": "(\\\\)",
    "lookup": {},
    "controlvisual": {},
    "validator": {},
    "ordinalposition": "12"
    }
    , { "name": "City",
    "heading": "City",
    "headingglobalizationenabled": "True",
    "sqlparamname": "",
    "datatype": "nvarchar",
    "datatypecharlength": "127",
    "datatypenumericprecision": "",
    "datatypenumericprecisionradix": "",
    "datatypenumericscale": "",
    "datatypedatetimeprecision": "",
    "allownulls": "False",
    "defaultvalue": "(\\\\)",
    "lookup": {},
    "controlvisual": {},
    "validator": {},
    "ordinalposition": "13"
    }
    , { "name": "SecurityUsersState_Region",
    "heading": "SecurityUsersState_Region",
    "headingglobalizationenabled": "True",
    "sqlparamname": "",
    "datatype": "nvarchar",
    "datatypecharlength": "3",
    "datatypenumericprecision": "",
    "datatypenumericprecisionradix": "",
    "datatypenumericscale": "",
    "datatypedatetimeprecision": "",
    "allownulls": "False",
    "defaultvalue": "(\\\\)",
    "lookup": {},
    "controlvisual": {},
    "validator": {},
    "ordinalposition": "14"
    }
    , { "name": "Province",
    "heading": "Province",
    "headingglobalizationenabled": "True",
    "sqlparamname": "",
    "datatype": "nvarchar",
    "datatypecharlength": "31",
    "datatypenumericprecision": "",
    "datatypenumericprecisionradix": "",
    "datatypenumericscale": "",
    "datatypedatetimeprecision": "",
    "allownulls": "False",
    "defaultvalue": "(\\\\)",
    "lookup": {},
    "controlvisual": {},
    "validator": {},
    "ordinalposition": "15"
    }
    , { "name": "Country",
    "heading": "Country",
    "headingglobalizationenabled": "True",
    "sqlparamname": "",
    "datatype": "nvarchar",
    "datatypecharlength": "2",
    "datatypenumericprecision": "",
    "datatypenumericprecisionradix": "",
    "datatypenumericscale": "",
    "datatypedatetimeprecision": "",
    "allownulls": "False",
    "defaultvalue": "(\\US\\)",
    "lookup": {},
    "controlvisual": {},
    "validator": {},
    "ordinalposition": "16"
    }
    , { "name": "SecurityUsersPostalCode",
    "heading": "SecurityUsersPostalCode",
    "headingglobalizationenabled": "True",
    "sqlparamname": "",
    "datatype": "nvarchar",
    "datatypecharlength": "10",
    "datatypenumericprecision": "",
    "datatypenumericprecisionradix": "",
    "datatypenumericscale": "",
    "datatypedatetimeprecision": "",
    "allownulls": "False",
    "defaultvalue": "(\\\\)",
    "lookup": {},
    "controlvisual": {},
    "validator": {},
    "ordinalposition": "17"
    }
    , { "name": "PhoneHome",
    "heading": "PhoneHome",
    "headingglobalizationenabled": "True",
    "sqlparamname": "",
    "datatype": "varchar",
    "datatypecharlength": "63",
    "datatypenumericprecision": "",
    "datatypenumericprecisionradix": "",
    "datatypenumericscale": "",
    "datatypedatetimeprecision": "",
    "allownulls": "False",
    "defaultvalue": "(\\\\)",
    "lookup": {},
    "controlvisual": {},
    "validator": {},
    "ordinalposition": "18"
    }
    , { "name": "PhoneWork",
    "heading": "PhoneWork",
    "headingglobalizationenabled": "True",
    "sqlparamname": "",
    "datatype": "varchar",
    "datatypecharlength": "63",
    "datatypenumericprecision": "",
    "datatypenumericprecisionradix": "",
    "datatypenumericscale": "",
    "datatypedatetimeprecision": "",
    "allownulls": "False",
    "defaultvalue": "(\\\\)",
    "lookup": {},
    "controlvisual": {},
    "validator": {},
    "ordinalposition": "19"
    }
    , { "name": , { "name": "isDisabled",
    "heading": "isDisabled",
    "headingglobalizationenabled": "True",
    "sqlparamname": "",
    "datatype": "char",
    "datatypecharlength": "1",
    "datatypenumericprecision": "",
    "datatypenumericprecisionradix": "",
    "datatypenumericscale": "",
    "datatypedatetimeprecision": "",
    "allownulls": "False",
    "defaultvalue": "(\\N\\)",
    "lookup": {},
    "controlvisual": {},
    "validator": {},
    "ordinalposition": "30"
    }
    , { "name": "CmsSecurityAliasLogin",
    "heading": "CmsSecurityAliasLogin",
    "headingglobalizationenabled": "True",
    "sqlparamname": "",
    "datatype": "char",
    "datatypecharlength": "32",
    "datatypenumericprecision": "",
    "datatypenumericprecisionradix": "",
    "datatypenumericscale": "",
    "datatypedatetimeprecision": "",
    "allownulls": "False",
    "defaultvalue": "(replace(convert(char(40),newid()),\\-\\,\\\\))",
    "lookup": {},
    "controlvisual": {},
    "validator": {},
    "ordinalposition": "31"
    }
    , { "name": "CmsSecurityAliasPassword",
    "heading": "CmsSecurityAliasPassword",
    "headingglobalizationenabled": "True",
    "sqlparamname": "",
    "datatype": "char",
    "datatypecharlength": "96",
    "datatypenumericprecision": "",
    "datatypenumericprecisionradix": "",
    "datatypenumericscale": "",
    "datatypedatetimeprecision": "",
    "allownulls": "False",
    "defaultvalue": "(replace(convert(char(40),newid()),\\-\\,\\\\) + replace(convert(char(40),newid()),\\-\\,\\\\) + replace(convert(char(40),newid()),\\-\\,\\\\))",
    "lookup": {},
    "controlvisual": {},
    "validator": {},
    "ordinalposition": "32"
    }
    , { "name": "LocalizationShortString",
    "heading": "LocalizationShortString",
    "headingglobalizationenabled": "True",
    "sqlparamname": "",
    "datatype": "varchar",
    "datatypecharlength": "5",
    "datatypenumericprecision": "",
    "datatypenumericprecisionradix": "",
    "datatypenumericscale": "",
    "datatypedatetimeprecision": "",
    "allownulls": "True",
    "defaultvalue": "",
    "lookup": {},
    "controlvisual": {},
    "validator": {},
    "ordinalposition": "33"
    }
    , { "name": "DateRegistered",
    "heading": "DateRegistered",
    "headingglobalizationenabled": "True",
    "sqlparamname": "",
    "datatype": "datetime",
    "datatypecharlength": "",
    "datatypenumericprecision": "",
    "datatypenumericprecisionradix": "",
    "datatypenumericscale": "",
    "datatypedatetimeprecision": "3",
    "allownulls": "True",
    "defaultvalue": "(getutcdate())",
    "lookup": {},
    "controlvisual": {},
    "validator": {},
    "ordinalposition": "34"
    }
    , { "name": "MiddleName",
    "heading": "MiddleName",
    "headingglobalizationenabled": "True",
    "sqlparamname": "",
    "datatype": "nvarchar",
    "datatypecharlength": "128",
    "datatypenumericprecision": "",
    "datatypenumericprecisionradix": "",
    "datatypenumericscale": "",
    "datatypedatetimeprecision": "",
    "allownulls": "True",
    "defaultvalue": "",
    "lookup": {},
    "controlvisual": {},
    "validator": {},
    "ordinalposition": "35"
    }
    ]
    }
    },{
    "schema" : {
    "manifest":{
    "datasetname": "FUNC.fn_Analysis_GetBaseData_SurveyInstances",
    "schemaformat": "JSON",
    "dataformat": "JSON",
    "encoding": "utf-8",
    "security": {},
    "cacheable": {}
    },
    "parameters":[
    { "name": "SecurityObjectUserID",
    "heading": "SecurityObjectUserID",
    "headingglobalizationenabled": "True",
    "sqlparamname": "@SecurityObjectUserID",
    "datatype": "bigint",
    "datatypecharlength": "",
    "datatypenumericprecision": "19",
    "datatypenumericprecisionradix": "10",
    "datatypenumericscale": "0",
    "datatypedatetimeprecision": "",
    "allownulls": "",
    "defaultvalue": "",
    "lookup": {},
    "controlvisual": {},
    "validator": {},
    "ordinalposition": "1"
    }
    , { "name": "ProtoSurveysAndClientIDsList",
    "heading": "ProtoSurveysAndClientIDsList",
    "headingglobalizationenabled": "True",
    "sqlparamname": "@ProtoSurveysAndClientIDsList",
    "datatype": "varchar",
    "datatypecharlength": "8000",
    "datatypenumericprecision": "",
    "datatypenumericprecisionradix": "",
    "datatypenumericscale": "",
    "datatypedatetimeprecision": "",
    "allownulls": "",
    "defaultvalue": "",
    "lookup": {},
    "controlvisual": {},
    "validator": {},
    "ordinalposition": "2"
    }
    , { "name": "dtStart",
    "heading": "dtStart",
    "headingglobalizationenabled": "True",
    "sqlparamname": "@dtStart",
    "datatype": "datetime",
    "datatypecharlength": "",
    "datatypenumericprecision": "",
    "datatypenumericprecisionradix": "",
    "datatypenumericscale": "",
    "datatypedatetimeprecision": "3",
    "allownulls": "",
    "defaultvalue": "",
    "lookup": {},
    "controlvisual": {},
    "validator": {},
    "ordinalposition": "3"
    }
    , { "name": "dtEnd",
    "heading": "dtEnd",
    "headingglobalizationenabled": "True",
    "sqlparamname": "@dtEnd",
    "datatype": "datetime",
    "datatypecharlength": "",
    "datatypenumericprecision": "",
    "datatypenumericprecisionradix": "",
    "datatypenumericscale": "",
    "datatypedatetimeprecision": "3",
    "allownulls": "",
    "defaultvalue": "",
    "lookup": {},
    "controlvisual": {},
    "validator": {},
    "ordinalposition": "4"
    }
    , { "name": "CampaignFilter",
    "heading": "CampaignFilter",
    "headingglobalizationenabled": "True",
    "sqlparamname": "@CampaignFilter",
    "datatype": "nvarchar",
    "datatypecharlength": "4000",
    "datatypenumericprecision": "",
    "datatypenumericprecisionradix": "",
    "datatypenumericscale": "",
    "datatypedatetimeprecision": "",
    "allownulls": "",
    "defaultvalue": "",
    "lookup": {},
    "controlvisual": {},
    "validator": {},
    "ordinalposition": "5"
    }
    , { "name": "LocationStoreIDList",
    "heading": "LocationStoreIDList",
    "headingglobalizationenabled": "True",
    "sqlparamname": "@LocationStoreIDList",
    "datatype": "nvarchar",
    "datatypecharlength": "4000",
    "datatypenumericprecision": "",
    "datatypenumericprecisionradix": "",
    "datatypenumericscale": "",
    "datatypedatetimeprecision": "",
    "allownulls": "",
    "defaultvalue": "",
    "lookup": {},
    "controlvisual": {},
    "validator": {},
    "ordinalposition": "6"
    }
    , { "name": "LocationNameList",
    "heading": "LocationNameList",
    "headingglobalizationenabled": "True",
    "sqlparamname": "@LocationNameList",
    "datatype": "nvarchar",
    "datatypecharlength": "4000",
    "datatypenumericprecision": "",
    "datatypenumericprecisionradix": "",
    "datatypenumericscale": "",
    "datatypedatetimeprecision": "",
    "allownulls": "",
    "defaultvalue": "",
    "lookup": {},
    "controlvisual": {},
    "validator": {},
    "ordinalposition": "7"
    }
    , { "name": "LocationStateList",
    "heading": "LocationStateList",
    "headingglobalizationenabled": "True",
    "sqlparamname": "@LocationStateList",
    "datatype": "nvarchar",
    "datatypecharlength": "4000",
    "datatypenumericprecision": "",
    "datatypenumericprecisionradix": "",
    "datatypenumericscale": "",
    "datatypedatetimeprecision": "",
    "allownulls": "",
    "defaultvalue": "",
    "lookup": {},
    "controlvisual": {},
    "validator": {},
    "ordinalposition": "8"
    }
    , { "name": "LocationCityList",
    "heading": "LocationCityList",
    "headingglobalizationenabled": "True",
    "sqlparamname": "@LocationCityList",
    "datatype": "nvarchar",
    "datatypecharlength": "4000",
    "datatypenumericprecision": "",
    "datatypenumericprecisionradix": "",
    "datatypenumericscale": "",
    "datatypedatetimeprecision": "",
    "allownulls": "",
    "defaultvalue": "",
    "lookup": {},
    "controlvisual": {},
    "validator": {},
    "ordinalposition": "9"
    }
    , { "name": "LocationPropertyList",
    "heading": "LocationPropertyList",
    "headingglobalizationenabled": "True",
    "sqlparamname": "@ShopperFirstName",
    "datatype": "nvarchar",
    "datatypecharlength": "4000",
    "datatypenumericprecision": "",
    "datatypenumericprecisionradix": "",
    "datatypenumericscale": "",
    "datatypedatetimeprecision": "",
    "allownulls": "",
    "defaultvalue": "",
    "lookup": {},
    "controlvisual": {},
    "validator": {},
    "ordinalposition": "13"
    }
    , { "name": "ClientLocationPropertiesOrder",
    "heading": "ClientLocationPropertiesOrder",
    "headingglobalizationenabled": "True",
    "sqlparamname": "@ClientLocationPropertiesOrder",
    "datatype": "nvarchar",
    "datatypecharlength": "4000",
    "datatypenumericprecision": "",
    "datatypenumericprecisionradix": "",
    "datatypenumericscale": "",
    "datatypedatetimeprecision": "",
    "allownulls": "",
    "defaultvalue": "",
    "lookup": {},
    "controlvisual": {},
    "validator": {},
    "ordinalposition": "14"
    }
    , { "name": "MiscSettings",
    "heading": "MiscSettings",
    "headingglobalizationenabled": "True",
    "sqlparamname": "@MiscSettings",
    "datatype": "nvarchar",
    "datatypecharlength": "4000",
    "datatypenumericprecision": "",
    "datatypenumericprecisionradix": "",
    "datatypenumericscale": "",
    "datatypedatetimeprecision": "",
    "allownulls": "",
    "defaultvalue": "",
    "lookup": {},
    "controlvisual": {},
    "validator": {},
    "ordinalposition": "15"
    }
    ],
    "columns":[
    { "name": "SurveyInstanceID",
    "heading": "SurveyInstanceID",
    "headingglobalizationenabled": "True",
    "sqlparamname": "",
    "datatype": "bigint",
    "datatypecharlength": "",
    "datatypenumericprecision": "19",
    "datatypenumericprecisionradix": "10",
    "datatypenumericscale": "0",
    "datatypedatetimeprecision": "",
    "allownulls": "False",
    "defaultvalue": "",
    "lookup": {},
    "controlvisual": {},
    "validator": {},
    "ordinalposition": "1"
    }
    , { "name": "CustLocationProperty001",
    "heading": "CustLocationProperty001",
    "headingglobalizationenabled": "True",
    "sqlparamname": "",
    "datatype": "nvarchar",
    "datatypecharlength": "100",
    "datatypenumericprecision": "",
    "datatypenumericprecisionradix": "",
    "datatypenumericscale": "",
    "datatypedatetimeprecision": "",
    "allownulls": "False",
    "defaultvalue": "(\\\\)",
    "lookup": {},
    "controlvisual": {},
    "validator": {},
    "ordinalposition": "2"
    }
    , { "name": "CustLocationProperty002",
    "heading": "CustLocationProperty002",
    "headingglobalizationenabled": "True",
    "sqlparamname": "",
    "datatype": "nvarchar",
    "datatypecharlength": "100",
    "datatypenumericprecision": "",
    "datatypenumericprecisionradix": "",
    "datatypenumericscale": "",
    "datatypedatetimeprecision": "",
    "allownulls": "False",
    "defaultvalue": "(\\\\)",
    "lookup": {},
    "controlvisual": {},
    "validator": {},
    "ordinalposition": "3"
    }
    , { "name": "CustLocationProperty003",
    "heading": "CustLocationProperty003",
    "headingglobalizationenabled": "True",
    "sqlparamname": "",
    "datatype": "nvarchar",
    "datatypecharlength": "100",
    "datatypenumericprecision": "",
    "datatypenumericprecisionradix": "",
    "datatypenumericscale": "",
    "datatypedatetimeprecision": "",
    "allownulls": "False",
    "defaultvalue": "(\\\\)",
    "lookup": {},
    "controlvisual": {},
    "validator": {},
    "ordinalposition": "4"
    }
    , { "name": "CustLocationProperty004",
    "heading": "CustLocationProperty004",
    "headingglobalizationenabled": "True",
    "sqlparamname": "",
    "datatype": "nvarchar",
    "datatypecharlength": "100",
    "datatypenumericprecision": "",
    "datatypenumericprecisionradix": "",
    "datatypenumericscale": "",
    "datatypedatetimeprecision": "",
    "allownulls": "False",
    "defaultvalue": "(\\\\)",
    "lookup": {},
    "controlvisual": {},
    "validator": {},
    "ordinalposition": "5"
    }
    , { "name": "CustLocationProperty005",
    "heading": "CustLocationProperty005",
    "headingglobalizationenabled": "True",
    "sqlparamname": "",
    "datatype": "nvarchar",
    "datatypecharlength": "100",
    "datatypenumericprecision": "",
    "datatypenumericprecisionradix": "",
    "datatypenumericscale": "",
    "datatypedatetimeprecision": "",
    "allownulls": "False",
    "defaultvalue": "(\\\\)",
    "lookup": {},
    "controlvisual": {},
    "validator": {},
    "ordinalposition": "6"
    }
    , { "name": "CustLocationProperty006",
    "heading": "CustLocationProperty006",
    "headingglobalizationenabled": "True",
    "sqlparamname": "",
    "datatype": "nvarchar",
    "datatypecharlength": "100",
    "datatypenumericprecision": "",
    "datatypenumericprecisionradix": "",
    "datatypenumericscale": "",
    "datatypedatetimeprecision": "",
    "allownulls": "False",
    "defaultvalue": "(\\\\)",
    "lookup": {},
    "controlvisual": {},
    "validator": {},
    "ordinalposition": "7"
    }
    , { "name": "CustLocationProperty007",
    "heading": "CustLocationProperty007",
    "headingglobalizationenabled": "True",
    "sqlparamname": "",
    "datatype": "nvarchar",
    "datatypecharlength": "100",
    "datatypenumericprecision": "",
    "datatypenumericprecisionradix": "",
    "datatypenumericscale": "",
    "datatypedatetimeprecision": "",
    "allownulls": "False",
    "defaultvalue": "(\\\\)",
    "lookup": {},
    "controlvisual": {},
    "validator": {},
    "ordinalposition": "8"
    }
    ]
    }
    },{
    "schema" : {
    "manifest":{
    "datasetname": "VIEW.vw_MystClients",
    "schemaformat": "JSON",
    "dataformat": "JSON",
    "encoding": "utf-8",
    "security": {},
    "cacheable": {}
    },
    "parameters":[
    ],
    "columns":[
    { "name": "Client<br>ID",
    "heading": "Client<br>ID",
    "headingglobalizationenabled": "True",
    "sqlparamname": "",
    "datatype": "int",
    "datatypecharlength": "",
    "datatypenumericprecision": "10",
    "datatypenumericprecisionradix": "10",
    "datatypenumericscale": "0",
    "datatypedatetimeprecision": "",
    "allownulls": "False",
    "defaultvalue": "",
    "lookup": {},
    "controlvisual": {},
    "validator": {},
    "ordinalposition": "1"
    }
    , { "name": "Client<br>Name",
    "heading": "Client<br>Name",
    "headingglobalizationenabled": "True",
    "sqlparamname": "",
    "datatype": "nvarchar",
    "datatypecharlength": "200",
    "datatypenumericprecision": "",
    "datatypenumericprecisionradix": "",
    "datatypenumericscale": "",
    "datatypedatetimeprecision": "",
    "allownulls": "True",
    "defaultvalue": "",
    "lookup": {},
    "controlvisual": {},
    "validator": {},
    "ordinalposition": "2"
    }
    , { "name": "Address",
    "heading": "Address",
    "headingglobalizationenabled": "True",
    "sqlparamname": "",
    "datatype": "nvarchar",
    "datatypecharlength": "150",
    "datatypenumericprecision": "",
    "datatypenumericprecisionradix": "",
    "datatypenumericscale": "",
    "datatypedatetimeprecision": "",
    "allownulls": "True",
    "defaultvalue": "",
    "lookup": {},
    "controlvisual": {},
    "validator": {},
    "ordinalposition": "3"
    }
    , { "name": "City",
    "heading": "City",
    "headingglobalizationenabled": "True",
    "sqlparamname": "",
    "datatype": "nvarchar",
    "datatypecharlength": "50",
    "datatypenumericprecision": "",
    "datatypenumericprecisionradix": "",
    "datatypenumericscale": "",
    "datatypedatetimeprecision": "",
    "allownulls": "True",
    "defaultvalue": "",
    "lookup": {},
    "controlvisual": {},
    "validator": {},
    "ordinalposition": "4"
    }
    , { "name": "State/<br>Region",
    "heading": "State/<br>Region",
    "headingglobalizationenabled": "True",
    "sqlparamname": "",
    "datatype": "nvarchar",
    "datatypecharlength": "67",
    "datatypenumericprecision": "",
    "datatypenumericprecisionradix": "",
    "datatypenumericscale": "",
    "datatypedatetimeprecision": "",
    "allownulls": "True",
    "defaultvalue": "",
    "lookup": {},
    "controlvisual": {},
    "validator": {},
    "ordinalposition": "5"
    }
    , {

IMN logo majestic logo threadwatch logo seochat tools logo