Forum Discussion

5AMsan's avatar
5AMsan
Frequent Visitor
3 years ago
Solved

Strange issue creating a custom connector

Hello world,

 

I'm triyng to achieve my fourth custom connector as I ran in a strange issue. 
While trying to caoncatenate strings I receive this error :
`We cannot convert the value "https://api....." to type Function`

But, using a full string instead of concatenated variables just work. 


Is is the relevant part of the code throwing the error:

 

api_base_uri =  "https://api.linkedin.com/v2";
[...]
url = if (next_url <> null ) 
      then next_url 
      else api_base_uri & "/organizationPageStatistics?" & Uri.BuildQueryString(  [ 
          q = "organization", 
          organization = organization_urn
      ] )

 

And the modifed part that just works: 

 

url = if (next_url <> null ) 
      then next_url 
      else "https://api.linkedin.com/v2" & "/organizationPageStatistics?" & Uri.BuildQueryString(  [ 
          q = "organization", 
          organization = organization_urn
      ] )

 

 

Any thought is welcome

  • Fixed

    I had a source kind definition tag(?) like '[DataSource.Kind="LinkedIn", Publish="LinkedIn.Publish"]' above API variables definition.

2 Replies

  • 5AMsan's avatar
    5AMsan
    Frequent Visitor

    Fixed

    I had a source kind definition tag(?) like '[DataSource.Kind="LinkedIn", Publish="LinkedIn.Publish"]' above API variables definition.

  • Anonymous's avatar
    Anonymous
    Not applicable

    HI 5AMsan,

    I think this may be related to the M query evaluation, these variable values seem not fully recognized when executing the concatenate operations. You can take a look at the evaluation model of power query if helps:

    Evaluation model - PowerQuery M | Microsoft Learn

    Regards,

    Xiaoxin Sheng