Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Support of JSONPath #299

Closed
Seddryck opened this issue Oct 7, 2017 · 1 comment
Closed

Support of JSONPath #299

Seddryck opened this issue Oct 7, 2017 · 1 comment

Comments

@Seddryck
Copy link
Owner

Seddryck commented Oct 7, 2017

It should be possible to specify a JSONPath to have something similar that the FLOWR xml query

<result-set>
  <json-source>
    <file>..\Csv\PurchaseOrders.json</file>
    <json-path>
      <from>$.PurchaseOrders[*].Items[*]</from>
      <select>!!.PurchaseOrderNumber</select>
      <select>$.PartNumber</select>
    </json-path>
  </json-source>
</result-set>

Tradiotnal JsonPath is supported (from NewtonSoft.Json.Linq) with the addition of the symbol ! equivalent to the .. in XPath (jump to the parent). This flavored feature is only supported at the beginning of a JsonExpression and in the select expressions

it's also supporting a remote url:

<json-source>
  <url>http://www.url.com/foo/bar.json</url>
   ...
</json-source>
@Seddryck
Copy link
Owner Author

Seddryck commented Nov 3, 2019

Beta available at https://ci.appveyor.com/project/Seddryck/nbi/builds/28578027/artifacts or 1.22.0-beta0015.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant