Json Export Please help

Discussion in 'Requests' started by sattam, Aug 19, 2025.

  1. sattam

    sattam Active Member


    Code:
    [#Menu: Gateway of Tally]
       
        Item: "Export WhatsApp JSON" : Alter : WhatsApp JSON Report
    
    [Report: WhatsAppJSONReport]
       
        Form    : WhatsApp JSON Form
        Title   : "WhatsApp JSON Export"
        Export Empty Fields:Yes
       
    [Form: WhatsApp JSON Form]
       
       
        Delete:XMLTag
        Full Object:Yes
        Belongs To:Yes
        Part    : WhatsApp JSON Part
        Height:40% Screen
        Width :100% Screen
        On:Form Accept:Yes:Form Accept
       
        On:Form Accept:Yes:Call:ExportWhatsAppJSONReport
        Option        : Small Size Form
       
    [Part: WhatsApp JSON Part]
       
        Line    : WhatsAppJSONLine
        Scroll  : Vertical
    
    [Line: WhatsAppJSONLine]
       
        Field   : WhatsAppJSONField1,WhatsAppJSONField2
    
    [Field: WhatsAppJSONField1]
       
        Use        : Name Field
        JSONTag : "to"
        Set As  : "911234567890"
       
    [Field: WhatsAppJSONField2]
       
        Fields    : WhatsAppJSONField3,WhatsAppJSONField4,WhatsAppJSONField5
        JSONTag : "content"
       
    [Field: WhatsAppJSONField3]
       
        Use        : Name Field
        JSONTag : "type"
        Set As  : "text"
       
    [Field: WhatsAppJSONField4]
       
        Use        : Name Field
        JSONTag : "body"
        Set As  : "hello Tdl world"
       
    [Field: WhatsAppJSONField5]
       
        Use        : Name Field
        JSONTag : "isPreviewUrl"
        Set As  : false
       
    [Function:ExportWhatsAppJSONReport]
       
        010:Set:SVExportFormat:$$SysName:UTF8JSON
        020:Set:SVExportLanguage:$$SysName:UTF8JSON
        030:Set:SVPrintFileName:"E:\Export\WhatsAppJSONReport.json"
        040:Export:WhatsApp JSON Report:Yes:Yes
    I get this result in json format

    {
    "to": "911234567890",
    "content": {
    "type": "text",
    "body": "hello Tdl world",
    "isPreviewUrl": "No"
    }
    }

    but I want this

    {
    "to": "911234567890",
    "content": {
    "type": "text",
    "body": "hello Tdl world",
    "isPreviewUrl": false
    }
    }
     


  2. sattam

    sattam Active Member


    HOW to export boolean from tally
    "isPreviewUrl": false
     


  3. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Try Binary --- 1 or 0
    "isPreviewUrl": 1
     


  4. sattam

    sattam Active Member


    you mean

    [Field: WhatsAppJSONField5]

    Use : Name Field
    JSONTag : "isPreviewUrl"
    Set As : 1
    but result is

    {
    "to": "911234567890",
    "content": {
    "type": "text",
    "body": "hello Tdl world",
    "isPreviewUrl": "1"
    }
    }
    I want this json export file

    {
    "to": "911234567890",
    "content": {
    "type": "text",
    "body": "hello Tdl world",
    "isPreviewUrl": false
    }
    }
     


  5. sattam

    sattam Active Member


    problem solved minor mistake

    [Field: WhatsAppJSONField5]

    Use : Logical Field
    JSONTag : "isPreviewUrl"
    Set As : False
     


Share This Page