Apex 24.1
I am trying to create a pdf file from a simple word template. Below is my word template. I uploaded it to my report layout.
Test PDF Generation
Hello {name.firstname}
My report query is also very simple:
select json_object('name' value json_object('firstname' value 'Super', 'lastname' value 'Man')) from dual
When I run the test I can get the file to be generated and downloaded. However, the tag {name.firstname} is replaced with blank.
I have tested other versions of the sql above .. but still not able to get it to replace the tag correctly.
Anyone knows what I am doing wrong?
thanks.