A JSON to JSON transformation library written in Java.
Jolt is a json to JSON transformation library written in java.
For more information, see the GitHub page.
Latest release: 0.1.6 released on Mar 28, 2022
Questions tagged [jolt]
1312 questions
0
votes
3 answers
How tracnform rest of json into one field value using jolt?
Here is the JSON input:
{
"myRootKey": {
"directMove": "directValue",
"marker": "THE_MARKER",
"someTextField": "someString",
"someObject": {
"someKey": "value"
}
}
}
the output should be:
{
"myRootKey": {
…
Cherry
- 31,309
- 66
- 224
- 364
-1
votes
1 answer
How to get the expected output using JoltTransforms in nifi?
Unable to transform the below Input json into expected format using JOLT.
Note:
FExchangeCurrency_ExchangeRate values need to get in 2nd row in Expected output.
Input:
[
{
"ExchangeCurrency": "INR",
"FExchangeCurrency": "AUD",
…
pandu
- 31
- 4
-1
votes
1 answer
Assign index as id to each element of a specific array
I have an input JSON :
{
"a": "foo",
"bunch": 123,
"of": "foo",
"other": "foo",
"keys": 123,
"contacts": [
{
"id": null,
"a": "foo",
"bunch": 123,
"of": "foo",
"other": "foo",
"keys": 123
},
…
Kyle
- 5,407
- 6
- 32
- 47
-1
votes
1 answer
How to add new key value pair in jolt in nifi?
Hi pls help with this jolt transformation.
Note:
If Environment exists then add new field numid and value is 1
If costcenter exists then add new field numid and the value is 2
Input:
[
{
"Environment": "net",
"BillingProfileId": 863,
…
Sathish
- 31
- 3
-1
votes
1 answer
How to change key name using JoltTransformJSON in Nifi
Pls help with this jolt transformation.
Note:
If there is field "ServiceFamily" then change the field name to
"tag1"
If there is field "PublisherName" then change the field name to
"tag2"
Input:
[
{
"ServiceFamily": "Compute",
…
Sathish
- 31
- 3
-1
votes
1 answer
How to split the nested JSON in Jolt specification
pls help me out wit this jolt specification. pls help me
Notes :
Resourcename is the last element of ResourceId which will be a new attribute that we need to add to the expected output
Tags field needs to be copied and splited as mentioned in the…
Sathish
- 31
- 3
-1
votes
1 answer
Jolt specification in apache nifi
input:
{
"eventid": "165",
"name": "High memory utilization",
"severity": "0",
"userid": "1",
"hosts": [
{
"hostid": "101",
"proxy_hostid": "0",
"host": "hostname",
"name": "name"
}
],
"relatedObject":…
Sathish
- 31
- 3
-1
votes
1 answer
How do i transform a nested json to Jolt in Apache NIFI
I have an API with the below JSON format:
{
"message": true,
"result": [
{
"category": "Device",
"total_count": 288,
"total_price": 1769005231,
"brands": [
{
"brand": "DD",
"total_count":…
bibiji
- 147
- 1
- 9
-1
votes
1 answer
How to remove parentheses in JSON data using Jolt
I have following JSON data, from which I want to remove the parentheses using Jolt:
Input
{
"tID": "8934894",
"deviceData": {
"tID": "8934894",
"active": true,
"status": "activated",
"name": "pqr"
},
"C": 132,
"nameData":…
neeraj
- 11
- 2
-1
votes
2 answers
Unable to transform stringfy json array of objects to json object using jolt transformer
Input json
"sales" : "[{\"Option\":\"Britania\",\"value\":\"200\"}{\"Option\":\"Parle\",\"value\":\"100\"}{\"Option\":\"mariegold\",\"value\":\"500\"}{\"Option\":\"snacks\",\"value\":\"200\"}]",
jolt transformer used
[
{
"operation":…
DHANANJAY RAGHAV
- 7
- 7
-1
votes
1 answer
Is there an online tool to generate the JSON Spec for a complex JSON payload?
I have a complex JSON payload with nested arrays. I need to create a JSON spec to output the same payload as I have today so that if the sending system added any new fields, I want them to be dropped.
I need this capability because in TIBCO's…
Sunil Lobo
- 3
- 1
-1
votes
2 answers
Jolt Transformation Spec for array of arrays
I hava a json input and expected output is below. please help me in generating the spec.
Input JSON:
{
"Features": [
"fields": [
{
"name": "featureName"
},
{
"name": "featureVersion"
…
hari krishna
- 35
- 5
-1
votes
1 answer
Jolt transformation - Create a new collection
I have this json on json input
{
"$id": "11343",
"nomeRota": "2310 - 2401",
"placa": "PAN0001",
"nomeMotorista": "Motorista Padrão Bauducco",
"codigoMotorista": null,
"dataSaida": "2020-06-29T06:00:00-03:00",
"dataChegada":…
-1
votes
1 answer
Need jolt specs for below transformation
could anyone help to convert below mention input json to desired output json using jolt ?
Here in treefield list i want to fetch "paramid" and "paramvalue" to first level for only matched "paramid", rest of the list items should be intact in that…
TJJ
- 31
- 1
- 7
-1
votes
1 answer
JOLT Spec to build arrays from group of similarly named keys
Trying to build a JOLT spec to put similarly named keys into an array, and strip off leading 6 characters. In below example, all keys starting with "fd1lk1" would go into array "Link1", keys starting with "fd1lk2" would go into array "Link2",…
MTaylor
- 1
- 1