Convert Excel to json or Base 64

追蹤

Maruthi Ellendula

• 2019年10月15日 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

• 正式評論

  

  AgilePoint NX Support

  • 2019年10月20日 19:14

  Hi Maruthi Ellendula, 

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

  Thank you.

  評論操作 永久連結
• 

  Maruthi Ellendula

  • 2019年10月21日 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

  評論操作 永久連結
• 

  sysberry GmbH

  • 2019年10月22日 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

  評論操作 永久連結

請登入寫評論。