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 scalar-query to get a Json value out of a database #632

Closed
Seddryck opened this issue Jan 17, 2021 · 1 comment
Closed

Support scalar-query to get a Json value out of a database #632

Seddryck opened this issue Jan 17, 2021 · 1 comment

Comments

@Seddryck
Copy link
Owner

When relying on Json features of SQL Server, it could be handy to retrieve the value of a stored procedure or query that is already returnd as a Json string.

<json-source>
  <scalar-query>exec MyStoredProcedure ("[{"id"=0}, {"id"=1}]")<scalar-query>
  <json-path>...</json-path>
</json-source>
@Seddryck Seddryck added this to the v1.23 milestone Jan 17, 2021
@Seddryck Seddryck changed the title Support scalar-query to get a Json value Support scalar-query to get a Json value out of a database Jan 17, 2021
@Seddryck
Copy link
Owner Author

Implemented and documented in 1.23.0-beta.164 or on nuget via Update-Package NBi.Framework -version 1.23.0-beta0164.

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