Home › Forums › Persistence › Data Sources › Binary IDs and Inbound Call Soap Request

Viewing 5 reply threads
  • Author
    Posts
    • June 14, 2019 at 11:03 am #10716
      Levon BarkerLevon Barker
      Participant

      Hi,

      I’m getting hung up trying to make a soap call to notify our NexJ application server that an inbound call is coming in. I need to pass in the CLCallReason.id into the soap request but the ID on the database we are using is in binary format (see attached binary_id.png).

      Any thoughts?

      Cheers,
      Levon

       

      0
      Attachments:
      You must be logged in to view attached files.
    • June 14, 2019 at 11:59 am #10725
      Shahzad Qureshishahzad.qureshi
      Keymaster

      Hi Levon,

      Could you try something like the following and let us know if this does the job?

      select CONVERT(varchar(32),id,2) as guid_text from ClCallReason;

      0
    • June 14, 2019 at 12:38 pm #10734
      Shahzad Qureshishahzad.qureshi
      Keymaster

      The above may not work. Please try the following. This one should do the trick

      select concat(’10’,CONVERT(varchar(32),id,2)) as guid_text from CLCallReason;

      I would like to know if my first sql worked or not.

      0
    • June 14, 2019 at 1:46 pm #10743
      Levon BarkerLevon Barker
      Participant

      Hi Shazad, that worked and you got me further. Thank you!

       

      0
    • June 14, 2019 at 1:54 pm #10752
      Shahzad Qureshishahzad.qureshi
      Keymaster

      No Problem. So I am assuming the second suggestion worked. Did you try the first one? I am curious myself.

      0
    • June 14, 2019 at 2:09 pm #10761
      Levon BarkerLevon Barker
      Participant

      The second suggestion worked. The first one did not. Now I’m stuck on getting a valid entry for transferCallId but that might be a new topic if I can’t figure it out.

      Cheers.
      Levon

      0
  • Author
    Posts
Viewing 5 reply threads
  • You must be logged in to reply to this topic.