Hi Everyone,
I am testing an API which sends data to Google Sheets. I am struggling to send data to sheets which is the first sheet. Would someone be able to help?
Solution:
Hi @GGB The Add Row node is working fine, the is that the sheet name you are using in the Get Sheets node is wrong, and it won't fetch the data. Seems you have mistakenly added the range in the sheet name. - Retirement Spending!B2:B24, on the Get Sheets, you can remove the range and confirm the sheet's name.
Also, if you execute a full workflow test and check the logs you should be able to see the inputs of the Add Row in the logs it is updating/adding rows to the correct sheet.
And the data format should be in this form
[...
Branch if statement help: Cannot read properties of undefined
I have a Rest API Call node at the top of my workflow. It has a query param called "api_key". For the next node, I have a branch node. I thought it would be simple to have an "if" statement with the branch.
So, in the branch node, I have this code: ctx["root"]["request"]["query"].api_key == '12345'
Then, on the true branch, I go ahead and run my next bit of code. On the false branch, I just return a message. ...
Solution:
@macphreak
The are a couple of issues in your workflow you submitted:
1. You are matching the condition to the wrong value due to which it is failing, the request header should match the value to which you are comparing. For example, if your request header is 123 then the match condition should be: (refer to the image below).
image.png...
Need help with my output.
We are building chatbot that helps us to provide what users need by using OpenAI Assistant and MySQL nodes. One thing we noticed is, we are getting random data or answers like the image attached. Is there a fix with this? Looking forward for your answers. Thank you!
Solution:
Hi @Gaurav Chadha , Thank you for your response! I will take a look. I appreciate you!
Issue with AI Auto-Fill Data Overlap
Hi @BuildShip team,
I am using the OpenAI Assistant node with a tool that makes an API POST request to save the name, email, and phone number of the user. The name, email, and phone number are all auto-filled by the AI. While this functionality generally works well for collecting this information during conversations with users, I have encountered an issue.
I have attached a screenshot as an example....
Solution:
@Jrocks, On checking the recent and the previous logs (which shows the issue) of your shared workflow via support the newer logs shows the correct values and does not repeats, As for the new logs if you compare the request inputs - the request body
email matches with the email of your Update Contact node's input. On latest logs.
We have found an issue that in some of the previous executions it used previous test data and repeated the executions twice, we are looking into this and will add a fix.
For now as a workaround, could you please delete and add the Assistant node again and give a try, and ship it again, it should perhaps solve this issue. Let us know if it works and occurs again....
Type 'unknown' when trying to use API
Hi, i'm trying to use API from openfoodfacts. I've followed the tutorial but still getting error "Property 'product_name' does not exist on type 'unknown' ". I've tried various options but the closest one is when my result in test mode shows {"name": undefined}. Any help would be appreciated 🥹
Solution:
@Shizuru You'll require to pass the barcode as key and the actual barcode in the value then test. Ensure you match the key as it is case sensitive.
Where do I find docs on how to add a header with a value to a rest API call ?
I want to add Authorization with a value but the "+" symbol seems to add a new element to the output ??
When I click on the "Request headers" I don't see anything for adding values to that property...
Any help or advice is appreciated ......
Solution:
To add an Authorization header, you'll require to add it under the Request Headers, ensuring the
type of the request headers is Object. You can clone this sample workflow - https://buildship.app/remix/ca544a0c-566c-4642-aa3b-729e7eb92474 which has an example.
Also, to learn more about headers and other components you can refer to this - https://docs.buildship.com/basics/ship-an-api and REST API Trigger docs - https://docs.buildship.com/trigger-nodes/rest-api....
BuildShip Database
I’m currently working with Firestore on my project and have come across Buildship, which I find very interesting. Regarding the Buildship database, I successfully integrated Firestore and can retrieve documents from my Firestore collection nodes without any issues. However, when I switch to the database view and try to create a table with the same name as my Firestore collection, I receive an error message saying, "There is no data in the Firestore collection." Could it be that this feature is o...
Solution:
@osmanFirat Both BuildShip database and Firestore database are different. BuildShip DB is an inbuilt Firestore database which comes with your project. It is not the one you access with your associated email outside BuildShip. You can refer to this conversation -https://discord.com/channels/853498675484819476/1246926649686097983/1247116854930047029.
