Read txt files and get MySQL data

[mapplechannel]

1.Hello, when I read the txt file, I found that the read data was not in json format and could not be operated on. My yaml is：
input:
label: ""
sftp:
address: "127.0.0.1:22"
credentials:
username: "admin"
password: "123456"
private_key_file: ""
private_key_pass: ""
paths: [/home/sftp_root/shared/123.txt]
codec: all-bytes
watcher:
enabled: false
minimum_age: 1s
poll_interval: 1s
cache: ""

pipeline:
processors: []

output:
label: ""
stdout:
codec: lines

Please tell me how I should configure it so that the txt content can be turned into a json format data，thanks

2.Another question is that when I read the int value of MySQL, I found that the obtained data became string type. How can I keep the data type unchanged, which is int?

[Jeffail]

Converting to a discussion as per: #2026