Neutrinos Studio( SSD ) Master Class Assignment

[Nehal]

@Eldho I wanted to check if there are any updates regarding my credential issue.

[Eldho]

@Tanveer is looking in to it will be closed soon

[Tanveer]

@Nehal We have re-registered you in SSD please check.

[Nehal]

Thank you, I am able to login

[jampalalokesh]

while i am trying to clone this repo ,it getting access denied message from atlassian jira through vs code

[Vyshnav_PC]

@jampalalokesh
The above mentioned repo is public, even i can access it from incognito mode please check the url is correct or not

git clone https://bitbucket.org/sankarshanaj/ssd-assignment.git

[jampalalokesh]

Yes I cleared the issue but when I click get apu/books it’s getting invalid what is the reason

[jampalalokesh]

please help me in this i created a table and after creating the flow ,api get method is not working

[sushobhan.banik]

Hi @Eldho / Team,

Our requirement is to retrieve book records from the public.books table using the ISBN value provided in the URL like:

http://localhost:8081/api/books/445rt

Here, 445rt is the ISBN value.

Neutrinos Studio Setup:

I’ve configured the SSD with the following nodes:

HTTP IN

Method: GET

Path: /api/books/:isbn

SQL SERVER NODE

PostgreSQL Query:

SELECT id, isbn, title, author, “publishedYear”

FROM public.records_books where isbn=‘445rt’;

So basically I need to pass the ISBN in the query from the server. Below please see the screen shot.

HTTP OUT Node

I need to returns the result of the SQL query as the HTTP response.

See the below image

The error from the Swagger is mentioned below

Please help how to do this steps and what needs to configure in the HTTPIN, SQL and HTTPOUT?

[Eldho]

@doomedCode can you please help

[Shamnad_KS]

Hi @sushobhan.banik ,

It looks like the path you provided in the HTTP IN node is missing the params.
You need to set the path as:
/books/:isbn

To access the ISBN value in your query, you can use:
bh.input.params.isbn

This will allow you to dynamically fetch the ISBN from the URL.

[sushobhan.banik]

@Shamnad_KS ,

I have added in the httpIn node but as I am fetching the the data from database so in the sql node do I need to follow the same step as u have mentioned?

[Shamnad_KS]

Yes, exactly!
Before using the SQL node, you can use a Script node to construct the query and store it in a local variable.

SELECT id, isbn, title, author, "publishedYear"
FROM public.records_books
WHERE isbn = '${bh.input.params.isbn}';

Then in the SQL node, set the query as: bh.local.query

[sumit.ghosh2]

@Shamnad_KS

SELECT id, isbn, title, author, "publishedYear"
FROM public.records_books
WHERE isbn = '${bh.input.params.isbn}';

@Shamnad_KS @Eldho

We are able follow the solution and it is working. We will let you know if we find difficulty in any further step. Thanks for your help.

[sushobhan.banik]

Hi Eldho/@Team,

I am facing one issue that payload is not defined but

See the below API workflow

This is the Post API
search | Open Library
And the body I am passing
{
“isbn”:“9777788000”
}
In my code I have called the external API and from that API I am getting the response but when trying to get the value and I am getting the from script node.

console.log(bh.local.result.payload); error below

Please help.

[Shamnad_KS]

Hi Sushobhan,

Could you please make sure that the response is correctly mapped to bh.local.result? Also, try logging bh.local.result first to check its structure before accessing payload.

[tuanndh]

Dear Team,

I cannot log in to Studio. Please take a look

[Sam]

@tuanndh please try forgot password option and get the new password and please verify if there is any trailing space in your credentials

[Poojita]

Hi, I am working on a Candidate Management POC using Neutrinos Alpha / N-Studio.
My middleware server is running on port 8081.
I can open Swagger API docs at
http://localhost:8081/api-docs.
All APIs are visible in Swagger.
Problem:
When I click Execute in Swagger, it does not return any response.
When I try the same API in Postman, the request to
http://localhost:8081/… does not work.
This happens for GET / POST / PUT APIs.
What I have checked:
Server is initialized successfully.
API services are created in SSD.
Database connection is configured.
Swagger UI loads correctly. Can anyone please help me.

[Poojita]

and also here even though have created the pages i am not able to see the pages in the navigate trigger. Please help me to solve the issue