Does anyone have any sample code on processing JSON data from a URL using Modified JavaScript Value in Java?

Question

Does anyone have any sample code on processing JSON data from a URL using Modified JavaScript Value in Java?

Could anyone provide some examples on how to handle returned Json data using Modified JavaScript Value? Here is the specific data I require from the json url:

{
"result": {
"data": [
{
"name": "page1",
"period": "dia",
"values": [
{
"value": 4,
"end_time": "2016-03-25"
},
{
"value": 2,
"end_time": "2016-03-26"
},
{
"value": 0,
"end_time": "2016-03-27"
}
],

},
{
"name": "page2",
"period": "dia",
"values": [
{
"value": 22,
"end_time": "2016-03-25"
},
{
"value": 30,
"end_time": "2016-03-26"
},
{
"value": 88,
"end_time": "2016-03-27"
}
],

}

I need to create rows for this data. Regards, Santana, Marcos

javascript json pentaho kettle data-integration

Answer 1

Answer №1

Appreciate the assistance, you are correct, no need for JavaScript, just JSON. However, I encountered a problem. I am able to capture the names, but not the values and dates. Here is what I attempted: $ .. Date []. Name $ .. Date []. Values (the issue lies here, it loads three values (value, end_time) when only one is needed. I tried $ .value but it resulted in an error indicating multiple values.

I figured it out, I utilized a step select value, split fields, and Row Normaliser.

Thank you very much! Santana, Marcos

Answer 2

Appreciate the assistance, you are correct, no need for JavaScript, just JSON. However, I encountered a problem. I am able to capture the names, but not the values and dates. Here is what I attempted: $ .. Date []. Name $ .. Date []. Values (the issue lies here, it loads three values (value, end_time) when only one is needed. I tried $ .value but it resulted in an error indicating multiple values.

I figured it out, I utilized a step select value, split fields, and Row Normaliser.

Thank you very much! Santana, Marcos

Answer 3

Answer №2

To optimize and speed up the process of populating rows with data, using JSON Input may be more effective. By specifying $..value and $..end_time in the Fields, you can easily generate rows.

If you prefer to use JavaScript (although JSON Input is recommended), below is a sample script to assist you:

var obj = JSON.parse(json);
datas = obj.result.data;
for (var i = 0; i < datas.length; i++) {
  var data = datas[i];
  for (var ii = 0; ii < data.values.length; ii++) {
    var value = data.values[ii];
    var row = createRowCopy(getOutputRowMeta().size());
    var idx = getInputRowMeta().size();
    row[idx++] = value.value;
    row[idx++] = value.end_time;
    putRow(row);
  }
}
trans_Status = SKIP_TRANSFORMATION;

Ensure that the output fields in the step include both "value" as string and "end_time" as string to capture the added values in the row.

Answer 4

To optimize and speed up the process of populating rows with data, using JSON Input may be more effective. By specifying $..value and $..end_time in the Fields, you can easily generate rows.

If you prefer to use JavaScript (although JSON Input is recommended), below is a sample script to assist you:

var obj = JSON.parse(json);
datas = obj.result.data;
for (var i = 0; i < datas.length; i++) {
  var data = datas[i];
  for (var ii = 0; ii < data.values.length; ii++) {
    var value = data.values[ii];
    var row = createRowCopy(getOutputRowMeta().size());
    var idx = getInputRowMeta().size();
    row[idx++] = value.value;
    row[idx++] = value.end_time;
    putRow(row);
  }
}
trans_Status = SKIP_TRANSFORMATION;

Ensure that the output fields in the step include both "value" as string and "end_time" as string to capture the added values in the row.

Does anyone have any sample code on processing JSON data from a URL using Modified JavaScript Value in Java?

Answer №1

Answer №2

Similar questions

Having an issue with the return function in a jQuery $.ajax call

Loop through each HTML element and store it in a JavaScript array

The absence of FormData.entries in submit is a limitation of the Vue framework

Avoiding memory leaks in Reactjs when canceling a subscription in an async promise

Is there a way to input the Sno data into the database in ascending order?

Enable the execution of a function only once a specific period of time has elapsed

Filter object in Angular to remove empty values

Encountering an issue with an Uncaught SyntaxError: Unexpected identifier

Replace all occurrences of a specific string throughout a extensive document in Node.js

Looking for a way to sort through data using the current time as a filter

Execute a script upon page load

Discover a demonstration showcasing login and registration functionalities by utilizing Flask, SQLAlchemy, Angular, and JSON

What's the best way to organize a list while implementing List Rendering in VueJS?

Using node.js to make an HTTP request and parse JSON data with the

NPM installation encounters enigmatic error stating "Unforeseen symbol in JSON"

Exploring Best Practices for Coding in node.js

Transforming flat JSON into nested JSON with multiple arrays can be achieved using the Jolt transform

Maximizing Efficiency: Utilizing a Single jQuery Function to Retrieve Specific Values

Sort through a collection of data using a specific keyword

The ng-repeat function is currently disabled and not displaying any data from the JSON object