I was able to get it through JOLT using below. Need to add attribute
extracted from JSON instead of test
[
{
"operation": "shift",
"spec": {
"*": "test_&"
}
}
]
On Thu, Jan 30, 2020 at 6:05 PM KhajaAsmath Mohammed <
[email protected]> wrote:
> Hi,,
>
> I have requirement where I need to add filename to attributes so that it
> would be easy for us to load into table by matching attribute name to
> columns in database.
>
> In this case we have 70 + json files having different attributes.
>
> "session": {
> "filename":"course",
> "id": "
> https://example.edu/sessions/1f6442a482de72ea6ad134943812bff564a76259";,
> "type": "Session",
> "user": "https://example.edu/users/554433";,
> "dateCreated": "2018-11-15T10:00:00.000Z",
> "startedAtTime": "2018-11-15T10:00:00.000Z"
> }
>
> "course_filename":"course",
> " course_id": "
> https://example.edu/sessions/1f6442a482de72ea6ad134943812bff564a76259";,
> " course_type": "Session",
> " course_user": "https://example.edu/users/554433";,
> " course_dateCreated": "2018-11-15T10:00:00.000Z",
> " course_startedAtTime": "2018-11-15T10:00:00.000Z"
>
> I am assuming it can be achieved through JOLT, would be really helpful if
> anyone has an idea on this.
>
> Thanks,
> Asmath
>
