building fails

[magiva]

if i build this, it says it cannot use the key as its password protected
if i replace the key and build, it says it cannot use newtonsoft.json

[geral2]

Hello there,

I will take a look tonight. So far could you try doing this Issue 9.

[geral2]

Does it worked?

[brad7100]

I have having the same issue. Issue 9 is not working for me.

[geral2]

So, @brad7100 is your issue related to NewtonSoft.Json or the key meanwhile build the project?.
Could you please upload a print screen?

[brad7100]

I was able to get it to work by setting the signassembly to false. Thank you for responding though.

…

On Oct 9, 2019, at 9:00 AM, Geraldo Diaz ***@***.***> wrote:  So, @brad7100 is your issue related to NewtonSoft.Json or the key meanwhile build the project?. Could you please upload a print screen? — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub, or mute the thread.

[geral2]

Awesome. I will upload a new version removing sign to the assembly. And it will include a Unit Test project.

[brad7100]

This works great and I am using it for several api's. I am having an issue getting it to work with one api thats using the following syntax 'http://username:[email protected]'. This api works and will get me a response every time outside of sql but when I use it with apicaller, I get '401 Please Authentiate error.' I can even hit ctrl+click on the url in SSMS and get the results to pop up on another tab so I know have the url correct.. What am I doing wrong?

[geral2]

@brad7100 what procedure are you using for this request?. Does this URL require authentication?

[brad7100]

I’m using Apicaller_Get and the username and password are passed in the url so no authentication.

…

On Oct 15, 2019, at 8:46 AM, Geraldo Diaz ***@***.***> wrote:  @brad7100 what procedure are you using for this request?. Does this URL require authentication? — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub, or unsubscribe.

[geral2]

Are you concatenating the username and password to the URL or just sending those values directly in the 'http://username:[email protected]'?

[brad7100]

I’m sending the values directly.

…

On Oct 15, 2019, at 9:21 AM, Geraldo Diaz ***@***.***> wrote:  Are you concatenating the username and password to the URL or just sending those values directly in the ***@***.***'? — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub, or unsubscribe.

[geral2]

Could you please try using the one below?

DECLARE @Credentials AS VARCHAR(MAX)
  
  SET @Credentials = CONCAT('Basic ','user:pass')
  
  EXEC [dbo].[APICaller_GETAuth] 
        'http://localhost:5000/api/values'
     ,   @Credentials

[brad7100]

Same error 401 Please Authenticate If it would help the api is https://rest.click2mail.com/molpro/projects Again I don’t have any issues calling this api using the web directly.

…

On Oct 15, 2019, at 10:27 AM, Geraldo Diaz ***@***.***> wrote:  Could you please try using the one below? DECLARE @credentials AS VARCHAR(MAX) SET @credentials = CONCAT('Basic ','user:pass') EXEC [dbo].[APICaller_GETAuth] 'http://localhost:5000/api/values' , @credentials — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub, or unsubscribe.

[geral2]

I figured out why it was failing. Just uploaded a new version that included an utility function that would help to make this API call. It was failing due the credectial was being expected as an array of bytes by this API.

You would need to redeploy the CLR and create that new function.

Try the code below and tell me how it goes. It worked for me.

DECLARE @byteArray AS NVARCHAR(MAX)

SELECT @byteArray = [dbo].fn_GetBytes('user:password')

DECLARE @Credentials AS VARCHAR(MAX)
  
SET @Credentials = CONCAT('Basic ',@byteArray)
  
  EXEC [dbo].[APICaller_GETAuth] 
        'https://rest.click2mail.com/molpro/projects'
     ,   @Credentials

[brad7100]

Thank you so much. I’ll give this a try later this morning.

…

On Oct 15, 2019, at 11:53 PM, Geraldo Diaz ***@***.***> wrote:  I figured out why it was failing. Just uploaded a new version that included an utility function that would help to make this API call. It was failing due the credectial was being expected as an array of bytes by this API. You would need to redeploy the CLR and create that new function. Try the code below and tell me how it goes. It worked for me. DECLARE @bytearray AS NVARCHAR(MAX) SELECT @bytearray = [dbo].fn_GetBytes('user:password') DECLARE @credentials AS VARCHAR(MAX) SET @credentials = CONCAT('Basic ***@***.***) EXEC [dbo].[APICaller_GETAuth] 'https://rest.click2mail.com/molpro/projects' , @credentials — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub, or unsubscribe.

[brad7100]

Worked great. Thank you again.

[geral2]

You're welcome. Any other issue just let me know.