Turbo Integrator: dynamically switching from a text file to a view data source

[Wim Gielis]

Hi all,

While I was playing around with some generic processes, I was testing the following setup.
A TI process has a text file data source type, taking the role of a template, from which we can dynamically change to other files / data sources like views, subsets, ODBC, etc.
I allow for 200 variables and mainly did that work in the *.PRO file for the process on the hard drive. Together with Notepad++ to increment series like 1 to 200, this was a breeze.
In the Advanced > Prolog tab of the process, it works fine when I want to dynamically override data source settings.

Then came the task to switch from a text file data source to a view data source. Oops, I got an error: "Variable "NVALUE" not found."
I know that NValue, SValue and Value_Is_String are special system variables: they are only available when the data source type is a view.
Hence, when switching to a view data source type, TM1 is still somehow expecting NValue, SValue and Value_Is_String.
If your process does not have code in the Metadata or Data tabs, then it runs fine (but is pretty useless!).
Once you have only 1 statement in the Metadata or Data tabs, then you receive the error right into your face.

Luckily, Google lead me to viewtopic.php?p=53278#p53278 (lotsaram, Wed Jan 07, 2015 1:00 pm) in the quite long topic found at: viewtopic.php?t=5170

Lotsaram and others were discussing there how to dynamically make the switch. AmbPin had the exact same question (and error) as me. It was suggested that the switch should start from a view data source, not from the text file data source.
This does not particularly please me. Why not have a TI process with a text file data source and still being able to make the switch ?
I found out that this is possible. You need to stop the TM1 model and go to the TI process on the hard drive. Open it up in Notepad++ or a different text editor.
You will notice codes. Be careful to only edit the PRO file where I instruct it. Here are the necessary changes/additions:

Code: Select all

In the section for 577, add 3 to the count of lines, and add at the end:
NValue
SValue
Value_Is_String

In the section for 578, add 3 to the count of lines, and add at the end:
1
2
1

In the section for 579, add 3 to the count of lines, and add at the end:
0
0
0

In the section for 580, add 3 to the count of lines, and add at the end:
0
0
0

In the section for 581, add 3 to the count of lines, and add at the end:
0
0
0

In the section for 582, do not change anything !

The count of lines always follows with a comma after the code number (577, 578, ...).
When you are ready, save the PRO file and start the TM1 model again. Now the 3 built-in variables NValue, SValue and Value_Is_String are available.
At the time of dynamically switching to a view data source, all is set and you are good to go.


@rclapp commented that it might be possible to do it with the TM1 REST API. I did not check that out, that's something for tomorrow.


Best regards,

Wim

[Wim Gielis]

Ryan was correct (no doubt about that one!)

Here is the JSON body to use in the TM1 REST API to set the variables:
- 200 string variables: V1 to V200
- NValue as a numeric variable
- SValue as a string variable
- Value_Is_String as a numeric variable

Code: Select all

{"Variables": [
        {
            "Name": "V1",
            "Type": "String",
            "Position": 1,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V2",
            "Type": "String",
            "Position": 2,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V3",
            "Type": "String",
            "Position": 3,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V4",
            "Type": "String",
            "Position": 4,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V5",
            "Type": "String",
            "Position": 5,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V6",
            "Type": "String",
            "Position": 6,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V7",
            "Type": "String",
            "Position": 7,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V8",
            "Type": "String",
            "Position": 8,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V9",
            "Type": "String",
            "Position": 9,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V10",
            "Type": "String",
            "Position": 10,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V11",
            "Type": "String",
            "Position": 11,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V12",
            "Type": "String",
            "Position": 12,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V13",
            "Type": "String",
            "Position": 13,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V14",
            "Type": "String",
            "Position": 14,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V15",
            "Type": "String",
            "Position": 15,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V16",
            "Type": "String",
            "Position": 16,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V17",
            "Type": "String",
            "Position": 17,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V18",
            "Type": "String",
            "Position": 18,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V19",
            "Type": "String",
            "Position": 19,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V20",
            "Type": "String",
            "Position": 20,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V21",
            "Type": "String",
            "Position": 21,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V22",
            "Type": "String",
            "Position": 22,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V23",
            "Type": "String",
            "Position": 23,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V24",
            "Type": "String",
            "Position": 24,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V25",
            "Type": "String",
            "Position": 25,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V26",
            "Type": "String",
            "Position": 26,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V27",
            "Type": "String",
            "Position": 27,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V28",
            "Type": "String",
            "Position": 28,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V29",
            "Type": "String",
            "Position": 29,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V30",
            "Type": "String",
            "Position": 30,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V31",
            "Type": "String",
            "Position": 31,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V32",
            "Type": "String",
            "Position": 32,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V33",
            "Type": "String",
            "Position": 33,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V34",
            "Type": "String",
            "Position": 34,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V35",
            "Type": "String",
            "Position": 35,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V36",
            "Type": "String",
            "Position": 36,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V37",
            "Type": "String",
            "Position": 37,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V38",
            "Type": "String",
            "Position": 38,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V39",
            "Type": "String",
            "Position": 39,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V40",
            "Type": "String",
            "Position": 40,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V41",
            "Type": "String",
            "Position": 41,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V42",
            "Type": "String",
            "Position": 42,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V43",
            "Type": "String",
            "Position": 43,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V44",
            "Type": "String",
            "Position": 44,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V45",
            "Type": "String",
            "Position": 45,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V46",
            "Type": "String",
            "Position": 46,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V47",
            "Type": "String",
            "Position": 47,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V48",
            "Type": "String",
            "Position": 48,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V49",
            "Type": "String",
            "Position": 49,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V50",
            "Type": "String",
            "Position": 50,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V51",
            "Type": "String",
            "Position": 51,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V52",
            "Type": "String",
            "Position": 52,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V53",
            "Type": "String",
            "Position": 53,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V54",
            "Type": "String",
            "Position": 54,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V55",
            "Type": "String",
            "Position": 55,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V56",
            "Type": "String",
            "Position": 56,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V57",
            "Type": "String",
            "Position": 57,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V58",
            "Type": "String",
            "Position": 58,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V59",
            "Type": "String",
            "Position": 59,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V60",
            "Type": "String",
            "Position": 60,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V61",
            "Type": "String",
            "Position": 61,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V62",
            "Type": "String",
            "Position": 62,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V63",
            "Type": "String",
            "Position": 63,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V64",
            "Type": "String",
            "Position": 64,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V65",
            "Type": "String",
            "Position": 65,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V66",
            "Type": "String",
            "Position": 66,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V67",
            "Type": "String",
            "Position": 67,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V68",
            "Type": "String",
            "Position": 68,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V69",
            "Type": "String",
            "Position": 69,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V70",
            "Type": "String",
            "Position": 70,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V71",
            "Type": "String",
            "Position": 71,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V72",
            "Type": "String",
            "Position": 72,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V73",
            "Type": "String",
            "Position": 73,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V74",
            "Type": "String",
            "Position": 74,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V75",
            "Type": "String",
            "Position": 75,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V76",
            "Type": "String",
            "Position": 76,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V77",
            "Type": "String",
            "Position": 77,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V78",
            "Type": "String",
            "Position": 78,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V79",
            "Type": "String",
            "Position": 79,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V80",
            "Type": "String",
            "Position": 80,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V81",
            "Type": "String",
            "Position": 81,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V82",
            "Type": "String",
            "Position": 82,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V83",
            "Type": "String",
            "Position": 83,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V84",
            "Type": "String",
            "Position": 84,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V85",
            "Type": "String",
            "Position": 85,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V86",
            "Type": "String",
            "Position": 86,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V87",
            "Type": "String",
            "Position": 87,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V88",
            "Type": "String",
            "Position": 88,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V89",
            "Type": "String",
            "Position": 89,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V90",
            "Type": "String",
            "Position": 90,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V91",
            "Type": "String",
            "Position": 91,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V92",
            "Type": "String",
            "Position": 92,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V93",
            "Type": "String",
            "Position": 93,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V94",
            "Type": "String",
            "Position": 94,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V95",
            "Type": "String",
            "Position": 95,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V96",
            "Type": "String",
            "Position": 96,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V97",
            "Type": "String",
            "Position": 97,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V98",
            "Type": "String",
            "Position": 98,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V99",
            "Type": "String",
            "Position": 99,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V100",
            "Type": "String",
            "Position": 100,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V101",
            "Type": "String",
            "Position": 101,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V102",
            "Type": "String",
            "Position": 102,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V103",
            "Type": "String",
            "Position": 103,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V104",
            "Type": "String",
            "Position": 104,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V105",
            "Type": "String",
            "Position": 105,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V106",
            "Type": "String",
            "Position": 106,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V107",
            "Type": "String",
            "Position": 107,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V108",
            "Type": "String",
            "Position": 108,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V109",
            "Type": "String",
            "Position": 109,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V110",
            "Type": "String",
            "Position": 110,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V111",
            "Type": "String",
            "Position": 111,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V112",
            "Type": "String",
            "Position": 112,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V113",
            "Type": "String",
            "Position": 113,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V114",
            "Type": "String",
            "Position": 114,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V115",
            "Type": "String",
            "Position": 115,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V116",
            "Type": "String",
            "Position": 116,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V117",
            "Type": "String",
            "Position": 117,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V118",
            "Type": "String",
            "Position": 118,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V119",
            "Type": "String",
            "Position": 119,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V120",
            "Type": "String",
            "Position": 120,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V121",
            "Type": "String",
            "Position": 121,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V122",
            "Type": "String",
            "Position": 122,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V123",
            "Type": "String",
            "Position": 123,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V124",
            "Type": "String",
            "Position": 124,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V125",
            "Type": "String",
            "Position": 125,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V126",
            "Type": "String",
            "Position": 126,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V127",
            "Type": "String",
            "Position": 127,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V128",
            "Type": "String",
            "Position": 128,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V129",
            "Type": "String",
            "Position": 129,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V130",
            "Type": "String",
            "Position": 130,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V131",
            "Type": "String",
            "Position": 131,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V132",
            "Type": "String",
            "Position": 132,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V133",
            "Type": "String",
            "Position": 133,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V134",
            "Type": "String",
            "Position": 134,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V135",
            "Type": "String",
            "Position": 135,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V136",
            "Type": "String",
            "Position": 136,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V137",
            "Type": "String",
            "Position": 137,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V138",
            "Type": "String",
            "Position": 138,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V139",
            "Type": "String",
            "Position": 139,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V140",
            "Type": "String",
            "Position": 140,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V141",
            "Type": "String",
            "Position": 141,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V142",
            "Type": "String",
            "Position": 142,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V143",
            "Type": "String",
            "Position": 143,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V144",
            "Type": "String",
            "Position": 144,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V145",
            "Type": "String",
            "Position": 145,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V146",
            "Type": "String",
            "Position": 146,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V147",
            "Type": "String",
            "Position": 147,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V148",
            "Type": "String",
            "Position": 148,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V149",
            "Type": "String",
            "Position": 149,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V150",
            "Type": "String",
            "Position": 150,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V151",
            "Type": "String",
            "Position": 151,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V152",
            "Type": "String",
            "Position": 152,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V153",
            "Type": "String",
            "Position": 153,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V154",
            "Type": "String",
            "Position": 154,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V155",
            "Type": "String",
            "Position": 155,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V156",
            "Type": "String",
            "Position": 156,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V157",
            "Type": "String",
            "Position": 157,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V158",
            "Type": "String",
            "Position": 158,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V159",
            "Type": "String",
            "Position": 159,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V160",
            "Type": "String",
            "Position": 160,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V161",
            "Type": "String",
            "Position": 161,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V162",
            "Type": "String",
            "Position": 162,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V163",
            "Type": "String",
            "Position": 163,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V164",
            "Type": "String",
            "Position": 164,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V165",
            "Type": "String",
            "Position": 165,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V166",
            "Type": "String",
            "Position": 166,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V167",
            "Type": "String",
            "Position": 167,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V168",
            "Type": "String",
            "Position": 168,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V169",
            "Type": "String",
            "Position": 169,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V170",
            "Type": "String",
            "Position": 170,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V171",
            "Type": "String",
            "Position": 171,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V172",
            "Type": "String",
            "Position": 172,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V173",
            "Type": "String",
            "Position": 173,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V174",
            "Type": "String",
            "Position": 174,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V175",
            "Type": "String",
            "Position": 175,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V176",
            "Type": "String",
            "Position": 176,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V177",
            "Type": "String",
            "Position": 177,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V178",
            "Type": "String",
            "Position": 178,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V179",
            "Type": "String",
            "Position": 179,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V180",
            "Type": "String",
            "Position": 180,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V181",
            "Type": "String",
            "Position": 181,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V182",
            "Type": "String",
            "Position": 182,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V183",
            "Type": "String",
            "Position": 183,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V184",
            "Type": "String",
            "Position": 184,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V185",
            "Type": "String",
            "Position": 185,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V186",
            "Type": "String",
            "Position": 186,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V187",
            "Type": "String",
            "Position": 187,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V188",
            "Type": "String",
            "Position": 188,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V189",
            "Type": "String",
            "Position": 189,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V190",
            "Type": "String",
            "Position": 190,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V191",
            "Type": "String",
            "Position": 191,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V192",
            "Type": "String",
            "Position": 192,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V193",
            "Type": "String",
            "Position": 193,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V194",
            "Type": "String",
            "Position": 194,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V195",
            "Type": "String",
            "Position": 195,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V196",
            "Type": "String",
            "Position": 196,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V197",
            "Type": "String",
            "Position": 197,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V198",
            "Type": "String",
            "Position": 198,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V199",
            "Type": "String",
            "Position": 199,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "V200",
            "Type": "String",
            "Position": 200,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "NValue",
            "Type": "Numeric",
            "Position": 201,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "SValue",
            "Type": "String",
            "Position": 202,
            "StartByte": 0,
            "EndByte": 0
        },
        {
            "Name": "Value_Is_String",
            "Type": "Numeric",
            "Position": 203,
            "StartByte": 0,
            "EndByte": 0
        }
    ]}

[lotsaram]

Devil's advocate here. Why do you need rest API? Wouldn't you get exactly the same result if you just used a text file with 202 columns and simply renamed the last 3 variables?

[Wim Gielis]

That's an option too Making sure that 2 are Numeric, 1 is String.

You could use an Excel file, write V1 and drag it across. Then change the last couple of variables.
Save as TXT and use as the source of a TI process.

[Wim Gielis]

Then came the task to switch from a text file data source to a view data source. Oops, I got an error: "Variable "NVALUE" not found."

IBM confirmed that this error will be solved in the latest 2.1.3 release (not out yet).