Convert Excel to json or Base 64

Follow

Maruthi Ellendula

• October 15, 2019 15:31

Hello,

 

I am trying to convert an excel to base 64 or Json format to use it as input to a rest call.

Thanks

1

• Official comment

  

  AgilePoint NX Support

  • October 20, 2019 19:14

  Hi Maruthi Ellendula, 

  Your question is uncertain to answer, can you please add more details to it.

  Thank you.

  Comment actions Permalink
• 

  Maruthi Ellendula

  • October 21, 2019 14:53

  Hello Team,

   

  I am trying to convert an .xlsx file to Base64 and send the base 64 code to an API.

  Excel to be converted to base 64

  

   

  I am using upload activity to upload the above excel.

  Requirement is to convert the above excel to base64 string

   

  Thanks

  Maruthi

  0

  Comment actions Permalink
• 

  sysberry GmbH

  • October 22, 2019 06:16

  Hello Maruthi,

  there is no out of the box possibility to store a file as base64 string in AgilePoint. You could go one of the following ways for that:
  1) create a stored procedure in a database, that takes the file path of the file and stores it in database as base64
  2) you can create a webservice, that takes the file path of the file and returns a base64 string back, that you could store in an agilepoint variable. With this approauch i would suggest to erase the variable after you used it to save space in AgilePoint database.

  Regards,
  Alexey

  0

  Comment actions Permalink

Please sign in to leave a comment.