From dev-return-19663-archive-asf-public=cust-asf.ponee.io@nifi.apache.org Mon Aug 26 05:53:58 2019 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [207.244.88.153]) by mx-eu-01.ponee.io (Postfix) with SMTP id 7ED95180645 for ; Mon, 26 Aug 2019 07:53:58 +0200 (CEST) Received: (qmail 30486 invoked by uid 500); 26 Aug 2019 05:53:57 -0000 Mailing-List: contact dev-help@nifi.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@nifi.apache.org Delivered-To: mailing list dev@nifi.apache.org Received: (qmail 30474 invoked by uid 99); 26 Aug 2019 05:53:57 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 26 Aug 2019 05:53:57 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 91CA21825C8 for ; Mon, 26 Aug 2019 05:53:56 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.8 X-Spam-Level: * X-Spam-Status: No, score=1.8 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=cloudera.com Received: from mx1-ec2-va.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id asLRk4qGfJpV for ; Mon, 26 Aug 2019 05:53:54 +0000 (UTC) Received-SPF: Pass (mailfrom) identity=mailfrom; client-ip=209.85.167.181; helo=mail-oi1-f181.google.com; envelope-from=turcsanyi@cloudera.com; receiver= Received: from mail-oi1-f181.google.com (mail-oi1-f181.google.com [209.85.167.181]) by mx1-ec2-va.apache.org (ASF Mail Server at mx1-ec2-va.apache.org) with ESMTPS id 1B5FFBC80B for ; Mon, 26 Aug 2019 05:53:54 +0000 (UTC) Received: by mail-oi1-f181.google.com with SMTP id o6so11223714oic.9 for ; Sun, 25 Aug 2019 22:53:54 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to; bh=Og7UL8EOA4+CCRHsU7GRN8u63tyubg932/yKrv1WI5Y=; b=AZ9RHHez18yxdLsGmP7KStTP7Yr/Imugy16aybat45aaMSXnNk7W+S3oJABQzpNqUD uUBKLo7sNVQoNPNgMp+Zozq1yBvZ6I06V2ZrsALAtgJCcZiIn2RQeJLCQQFb7Rea1J2K nvJPGEU/FSLom9nVG9/DAOurZ8IeIqJlj4aucgsYSkErY2vCYWVI4f5t6FPChx1ey4Q0 CL8oixnLKL5B79JUxAI/wpV0W2NKCveGtbBm14FP3CZs12npbEJyZyX/Uiqdp37Lx2s1 3DhfJ2LHVJhKzgr59vXvg/1rMz7yYBWlgC+iQg+HpvLV13UoshmLU3E2Y+W27Ad6F3fm /6nw== X-Gm-Message-State: APjAAAUzKVT1mA+/ow606azN+mxtTk89lvBEYSTIzUp1qO7B96Zn8TOK MLu6q9ubzbRibhSRiKJ/sb72QadMwbIEKa/FDkmLDd7YiVg= X-Google-Smtp-Source: APXvYqxgNvFnA09p1RdER1wexlJChpU/nL+Oyij3Jf5S62ODu2SwcFpN538AO7Vkf0Eup6J3V8nUNIMpZWS0KJjZZ0w= X-Received: by 2002:aca:518a:: with SMTP id f132mr10837401oib.114.1566798833029; Sun, 25 Aug 2019 22:53:53 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Peter Turcsanyi Date: Mon, 26 Aug 2019 07:53:42 +0200 Message-ID: Subject: Re: convert json to csv on nifi To: dev@nifi.apache.org Content-Type: multipart/alternative; boundary="000000000000e0bc310590fec793" --000000000000e0bc310590fec793 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi Anushke, What is the json path you would like to evaluate? The only array (that could be the target of SplitJson) is inside "details". "details" is of type string which contains escaped json content so it won't be parsed. Is the escaping intentional? Kind regards, Peter On Sun, Aug 25, 2019 at 9:44 PM Anushka Hewawitharana wrote: > Dear Team, > > I have listen json kafka feed and put to flat files using nifi > Now i need to convert them to csv using nifi. > > > > But i have error on "json path" attribute on splitjson processor. > My sample json as below. > > { > "section":"prepaid_myplan", > "action":"change_mypaln", > "sender":null, > "recipient":null, > > "details":"{\"channel\":\"SCAPP\",\"planId\":\"1\",\"serviceAmounts\":[{\= "serviceId\":\"5\",\"usageAmount\":\"0\"},{\"serviceId\":\"4\",\"usageAmoun= t\":\"0\"},{\"serviceId\":\"1\",\"usageAmount\":\"0\"},{\"serviceId\":\"2\"= ,\"usageAmount\":\"50\"}],\"totalValue\":\"137700\"}", > "amount":null, > "account_no":null, > "datetime":"2011-08-20 11:18:38", > "msisdn":"555555555", > "imei":"null", > "nic":"155555504555", > "lob":"MOBILE", > "deviceOs":"android", > "appVersion":"9.0.0", > "deviceModelId":"MSM55574", > "connType":"PREPAID", > "language":"en", > "device_id":null, > "status":"SUCCESS" > } > > kindly advise me on json path for above > > > > Regards > Anushke > > > > > --000000000000e0bc310590fec793--