topic Re: We cannot convert the value "[Binary]" to type Text in DAX Commands and Tips

We cannot convert the value "[Binary]" to type Text

jumercor — Wed, 24 Apr 2024 16:14:41 GMT

Hi everyone,

I'm trying to get data from hubspot API to powerbi using a POST method. I'm using this code to get the data but for some reason i'm receiving this error:

We cannot convert the value "[Binary]" to type Text

Details:
Value=[Binary]
Type=[Type]

let
data = "{'properties': [
'hs_survey_type'
],
'filterGroups':[{

'filters':[
{
'propertyName':'hs_createdate',
'operator':'BETWEEN',
'highValue': '1705552000000',
'value':'1704064000000'
},
{
'propertyName':'hs_survey_type',
'operator':'EQ',
'value':'CSAT'
}

]
}
]
}",
baseuri = "https://api.hubapi.com/crm/v3/objects/feedback_submissions/search",
initReq = Json.Document(Web.Contents(baseuri, [Headers = [Authorization="Bearer HERE_THE_TOKEN", #"Content-Type"="application/json", Content= Json.FromValue(data)]])),

initData = initReq[results]

in
initData

What might i am doing wrong?

Re: We cannot convert the value "[Binary]" to type Text

Sahir_Maharaj — Wed, 24 Apr 2024 21:46:30 GMT

Hello jumercor,

Can you please try this:

let data = "{'properties': [ 'hs_survey_type' ], 'filterGroups':[{ 'filters':[ { 'propertyName':'hs_createdate', 'operator':'BETWEEN', 'highValue': '1705552000000', 'value':'1704064000000' }, { 'propertyName':'hs_survey_type', 'operator':'EQ', 'value':'CSAT' } ] } ]}", baseuri = "https://api.hubapi.com/crm/v3/objects/feedback_submissions/search", content = Json.FromValue(Text.FromBinary(data)), headers = [ Authorization="Bearer HERE_THE_TOKEN", #"Content-Type"="application/json" ], response = Web.Contents(baseuri, [ Content=content, Headers=headers, Method="POST" ]), responseText = Text.FromBinary(response), initReq = Json.Document(responseText), initData = initReq[results] in initData

Re: We cannot convert the value "[Binary]" to type Text

jumercor — Wed, 24 Apr 2024 21:56:58 GMT

Thanks, but I'm receiving -> Expression.Error: "Method" is not a valid option for Web.Contents. Valid options:

ApiKeyName, Content, ExcludedFromCacheKey, Headers, IsRetry, ManualStatusHandling, Query, RelativePath, Timeout

Re: We cannot convert the value "[Binary]" to type Text

lbendlin — Thu, 25 Apr 2024 00:20:15 GMT

You don't need to specify Method. It is sufficient to provide a content payload, that will switch We.Contents from GET to POST automatically.

Re: We cannot convert the value "[Binary]" to type Text

jumercor — Thu, 25 Apr 2024 14:32:38 GMT

Thanks everyone, I solved it by myself. Here you can check the final solution:

let
data = "{""properties"":[""hs_survey_type""],""filterGroups"":[{""filters"":[{""propertyName"":""hs_createdate"",""operator"":""BETWEEN"",""highValue"":""1705552000000"",""value"":""1704064000000""},{""propertyName"":""hs_survey_type"",""operator"":""EQ"",""value"":""CSAT""}]}]}",
baseuri = "https://api.hubapi.com/crm/v3/objects/feedback_submissions/search",
initReq = Json.Document(Web.Contents(baseuri, [
Headers = [
Authorization="Bearer HERE_THE_TOKEN",
#"Content-Type"="application/json"
],
Content=Text.ToBinary(data)
])),
initData = initReq[results]
in
initData

First I moved 'Content' into web.contents parameters, and also I reformated 'data' from a text o a binary using Text.ToBinary