jq filter - VisualCron - Forum

Community forum

Danny van Oijen
2020-07-22T07:55:37Z
Hi all,

I have a question about the jq filter expression.

When i have the below json output:

[
  {
    "name": "domain1",
    "extension": "com"
  },
  {
    "name": "domain2",
    "extension": "com"
  }
]


i want the output to be:
domain1.com
domain2.com

When i go to https://jqplay.org/  and enther this as JSON than use this filter:
.[]|(.name+"."+.extension)

It works but when i use the filter in visualcron as jq filter it says: Access is denied.
Support
2020-07-24T13:18:19Z
Originally Posted by: Danny van Oijen 

Hi all,

I have a question about the jq filter expression.

When i have the below json output:

[
  {
    "name": "domain1",
    "extension": "com"
  },
  {
    "name": "domain2",
    "extension": "com"
  }
]


i want the output to be:
domain1.com
domain2.com

When i go to https://jqplay.org/  and enther this as JSON than use this filter:
.[]|(.name+"."+.extension)

It works but when i use the filter in visualcron as jq filter it says: Access is denied.



Can you take a screenshot of the error please? And upload it or send to support@visualcron.com

Michael
Support
http://www.visualcron.com 

Please like  VisualCron on facebook!
Danny van Oijen
2020-07-24T13:35:33Z
Error is just: Access is denied. in the result field.
Knipsel.PNG
Support
2020-08-07T09:24:00Z
Originally Posted by: Danny van Oijen 

Error is just: Access is denied. in the result field.
Knipsel.PNG



Hi Danny,

Apologize for the long delay. I just wanted to check up on the issue, are you still having the issue?
Michael
Support
http://www.visualcron.com 

Please like  VisualCron on facebook!
Danny van Oijen
2020-08-10T07:18:06Z
Michael,

Yes same issue still.
Support
2020-08-12T09:50:56Z
Originally Posted by: Danny van Oijen 

Michael,

Yes same issue still.



Thanks,

We were able to reproduce this. We'll update this thread once we've fixed this issue.
Michael
Support
http://www.visualcron.com 

Please like  VisualCron on facebook!
Support
2020-08-14T10:19:08Z
Originally Posted by: Danny van Oijen 

Michael,

Yes same issue still.



Hi Danny,

I just wanted to let you know that we've fixed this issue now. You can find the fixed build here: https://www.visualcron.c...aspx?g=Posts&t=10013 
Michael
Support
http://www.visualcron.com 

Please like  VisualCron on facebook!
Danny van Oijen
2020-08-14T10:20:31Z
Michael,

Thanks!!! will test it when i am back from the holiday.
Danny van Oijen
2020-09-01T07:24:29Z
Michael,

Almost ok,
It now works when there are mutilple entries, but a single entry still show access denied.
Here is what i mean:

When the output is:
[
  {
    "name": "domain1",
    "extension": "com"
  },
  {
    "name": "domain2",
    "extension": "com"
  }
]

The result is ok, i get what i expect.

When the output is:
{
  "name": "domain3",
  "extension": "com"
}


Than i get Access denied.
Danny van Oijen
2020-09-01T07:29:58Z
When i change the filter to:
.|(.name+"."+.extension)

Than it works for 1 domain but than the others fail.
This however is correct behavior as the brackets [ and ] are missing when there is 1 result.
Support
2020-11-11T17:20:34Z
Originally Posted by: Danny van Oijen 

Hi all,

I have a question about the jq filter expression.

When i have the below json output:

[
  {
    "name": "domain1",
    "extension": "com"
  },
  {
    "name": "domain2",
    "extension": "com"
  }
]


i want the output to be:
domain1.com
domain2.com

When i go to https://jqplay.org/  and enther this as JSON than use this filter:
.[]|(.name+"."+.extension)

It works but when i use the filter in visualcron as jq filter it says: Access is denied.



Hi, here is some feedback from our developer:

"the filter assumes that the input data will describe an array of objects, and the user wants him to be able to supply a single object instead of an array. but jd doesn't work like that."
image_2020_11_11T17_14_59_131Z.png
Michael
Support
http://www.visualcron.com 

Please like  VisualCron on facebook!
Scroll to Top