Saving csv in UTF-8 by default
Hi Gooday,
I have a requirement to save the csv file in UTF-8 by default . However in csv formatter we have UTF-8 encoding option , on writing the file in “File Writer” using externsion.csv it is ...
Forum Discussion
Can you tell me more about adding output view? What snap do I need to add after File Writer?
Thanks
@mtran21 Open file writer, then go to view tab click on + icon besides output as shown below. I believe you have used sftp url correctly like -
sftp://:// with valid account
yes @gowdhaman008 I know these things .I have tried in that way also . Same error is coming .
I have tried with this :
"{
"remove": { "index": $CURRENT_IDX, "alias": ${_IDX_ALIAS}$Suffix_batch }}"
My main issues is for the concatenate part . That is giving the trouble .
The following is working just fine 🙂
"{
"remove": { "index": $CURRENT_IDX, "alias": ${_IDX_ALIAS} }}"
@Rudradip This is a follow up after a considerable period of time but I wanted to answer the question.
Assuming in input document to the JSON Generator like:
{ "Body": "456", }This concatenation in the JSON Generator WILL NOT work:
[ { "Response": { "Message": "Thank you for your message, which was $Body" } } ]and will result in an error like
Failed to validate the output Resolution: Verify that the table values and the template are correct Reason: Unexpected character ('4' (code 52)): was expecting comma to separate Object entriesBut if you use a Velocity Directive, the following WILL work:
#set( $message = "Thank you for your message, which was $Body" ) [ { "Response": { "Message": $message } } ]The output document will look like:
[{ "Response": { "Message": "Thank you for your message, which was \"456\"" } }]Do note that the
$Bodyvalue has been wrapped in quotes. I’ll investigate if there is a way to remove those.Thanks. This is very helpful
