Forum Discussion

Richard_Halsall's avatar
Richard_Halsall
Helper IV
1 year ago
Solved

JSON query text error Monday.com api

Hi   I require help with an error I am receiving when querying the Monday.com api, I have tried multiple versions but just can't seem to resolve   I have 2 versions of the query and both are retu...
Need Help
  • Richard_Halsall's avatar
    Richard_Halsall
    1 year ago

    Hi thanks for taking the time to review and yes id_group1 is text

     

    Had a lightbulb moment and amended the parameter value in PQ to replicate what I have in Postman for id_group1 rather than trying to build through the code and it now works.

     

lbendlin's avatar
lbendlin
Super User
1 year ago

so you are absolutely sure that  id_group1 is a text?  Maybe use

 

Group = Text.From(id_group1),

 

Also, could be a freak coincendence that "Group"  is a reserved word?

Richard_Halsall's avatar
Richard_Halsall
Helper IV
1 year ago

Hi thanks for taking the time to review and yes id_group1 is text

 

Had a lightbulb moment and amended the parameter value in PQ to replicate what I have in Postman for id_group1 rather than trying to build through the code and it now works.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Richard_Halsall ,

     

    Thanks for reaching out to the Microsoft fabric community forum.

    I hope your issue has been resolved. If so, please mark the helpful reply and accept it as the solution. This will assist other community members with similar problems in resolving them more quickly.

     

    Thank you.