question Re: Json Array data conversion in Support Questions

Json Array data conversion

AbhishekSingh — Tue, 12 Jul 2022 17:19:21 GMT

Hi,

I want to convert some of the field value like "enrolled_at":"Sun Oct 17 15:58:58 IST 2021" -> DateTime(2021-10-17 15:58:58) and "is_deleted":"{0}" -> boolean(true or false) from below Json array to save converted data in db. How i can achieve it in NiFi.

[{"id":234521,"tenant_id":1,"product_id":1,"version":"3","user_id":197172,"user_ref_id":"8TS-0516","org_id":910,"org_subscription_id":7294,"access_code":null,"order_ref_id":null,"access_code_id":null,"enrol_type":"Admin4","enrolled_at":"Sun Oct 17 15:58:58 IST 2021","subscription_start_at":"Wed Oct 13 15:58:58 IST 2021","subscription_end_at":"Sat Oct 23 15:58:58 IST 2021","product_launched_at":"Wed Oct 13 16:05:49 IST 2021","product_completed_at":"Wed Oct 13 16:15:44 IST 2021","learning_completed_at":"Wed Oct 13 16:15:44 IST 2021","subscription_status":"ACTIVE","learning_status":"COMPLETED","total_credits":null,"completion_certificate_id":3585,"ecard_id":35867,"certificate_number":"tocubg3sfbkzfgfqslnisnci","ecard_number":"1hr5w9jkpikonazrfhqquauh","online_completion_date":"Wed Oct 13 16:08:07 IST 2021","offline_completion_date":"Wed Oct 13 16:15:44 IST 2021","ecard_date":"Tue Oct 31 16:15:44 IST 2023","is_deleted":"{0}","created_by":1,"updated_by":14302,"org_Name":"International Society","assignment_id":961,"last_activity_at":"Wed Oct 13 16:15:44 IST 2021","updated_at":"Wed Oct 13 16:15:44 IST 2021","source_lms":null,"course_instance_id":"20-3583"}]

Re: Json Array data conversion

araujo — Wed, 13 Jul 2022 02:50:33 GMT

@AbhishekSingh

You can use the UpdateRecord processor for this with the following configuration:

/is_deleted_bool -> contains(/is_deleted, "{1}") /subscription_start_at_timestamp -> toDate(/subscription_start_at, "EEE MMM d HH:mm:ss z yyyy")

The output of that will look like the below:

[ { ... "subscription_start_at" : "Wed Oct 13 15:58:58 IST 2021", ... "is_deleted" : "{0}", ... "is_deleted_bool" : false, "subscription_start_at_timestamp" : "1634133538000" } ]

Cheers,

André

Re: Json Array data conversion

AbhishekSingh — Wed, 13 Jul 2022 05:35:29 GMT

@araujo

I want to convert it to DateTime format like: 2021-10-17 15:58:58 not in timstamp.

is there possible here to convert it to datetime formate like yyyy-MM-dd hh:mm:ss ?

Re: Json Array data conversion

araujo — Wed, 13 Jul 2022 13:42:02 GMT

@AbhishekSingh ,

You can use the following expression instead to format the date as you want in the UpdateRecord processor:

/subscription_start_at_timestamp -> format(toDate(/subscription_start_at, "EEE MMM d HH:mm:ss z yyyy"), "yyyy-MM-dd HH:mm:ss")

Cheers,

André