How to send text message,the datatable of querying database, with line notify?

Help Studio
, ,
1

Hi everyone, I was wondering how i can send the datatable with line notify. I’ve already query the data i want and i need to send “these” data with line notify in one message. What should i do with my data before i send them?

2

Hello @jojo11050702

  1. Read Data: Use appropriate activities to read your data into a DataTable.
  2. Format Data: Format the data as a table using HTML or plain text.
  3. HTTP Request Activity:
  • Method: POST
  • Endpoint: https://notify-api.line.me/api/notify
  • Headers:
    • "Authorization" with value "Bearer YOUR_LINE_NOTIFY_TOKEN"
  • Input: application/x-www-form-urlencoded
  • Body: Create a dictionary with a single key "message" and the formatted message as the value.

Thanks & Cheers!!!

3

Thanks for replying me, I’ve already send one message with notify. Now i want to send the datatable which has several data in one message. Should i convert my datatable into json format?

4
  • Sequence
    • Read Data (e.g., Excel Application Scope)
    • Serialize JSON
      • Input: YourDataTable
      • Output: serializedJsonData (String variable)
    • Assign message = “Here is the data:\n” + serializedJsonData
    • HTTP Request
      • Method: POST
      • Endpoint: https://notify-api.line.me/api/notify
      • Headers:
        • Add “Authorization” header: “Bearer YOUR_LINE_NOTIFY_TOKEN”
      • Input: application/x-www-form-urlencoded
      • Body: { “message”: message }
5

Can i just use my datatable as the input argument for serializedJsonData()?

6

Yeah sure @jojo11050702

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.