Jeremy Posted August 5, 2020 Posted August 5, 2020 We have a google sheets integration in a BPM and have found that it is not displaying the name of the sheet, leaving us sometimes unsure of what sheet this points too. See below for example: You can search and add it: and you can save and publish the flow with no issues, but when you go back in it is missing and so don't know what sheet this is linking too. Could someone check to see why this data is not being kept in the node and displayed please?
Steve G Posted August 5, 2020 Posted August 5, 2020 Hi @Jeremy, I've just given this a whirl, and I'm unable to replicate the issue Are there any information/errors presented in the browser console, as per ther toast message? If not, could you check the response of the call to the iBridgeInvoke API that is made when you visit the node (via the Network tab in the browser developer tools), then this should give us a more descriptive error in the response: Cheers, Steve
Jeremy Posted August 5, 2020 Author Posted August 5, 2020 @Steve G this is the status when I click into the node you get this error and the associated network messages
Steve G Posted August 5, 2020 Posted August 5, 2020 Thanks @Jeremy. I can't see the error from that screenhot though I'm afraid. I'll need to see the content of the state object, could you expand that and let me know what's in there, please? Thanks, Steve
Jeremy Posted August 5, 2020 Author Posted August 5, 2020 @Steve G sorry here you go... {@status: "fail", state: {code: "0200", service: "bpm", operation: "iBridgeInvoke",…}} @status: "fail" state: {code: "0200", service: "bpm", operation: "iBridgeInvoke",…} code: "0200" error: "iBridge Method: /Google/Sheets/DataSources.system/Search Files.m Error: {"errors":[{"domain":"global","reason":"notFound","message":"File not found: 1X8DvTeG03xEXT0Zr4oOVvv9t0LcX7MziJ9WBgzpxjsU.","locationType":"parameter","location":"fileId"}],"code":404,"message":"File not found: 1X8DvTeG03xEXT0Zr4oOVvv9t0LcX7MziJ9WBgzpxjsU."}" operation: "iBridgeInvoke" service: "bpm"
Jeremy Posted August 13, 2020 Author Posted August 13, 2020 @Steve G have you had a chance to look at this to see what this issue could be?
Steve G Posted August 19, 2020 Posted August 19, 2020 Hi @Jeremy, Apologies for the late reply, I've been on holiday. I had a look at this issue before I went on leave, and could not replicate it. The ID from the original file search is being saved correctly, could you compare the ID from your message (1X8DvTeG03xEXT0Zr4oOVvv9t0LcX7MziJ9WBgzpxjsU) with the one in Google Sheets, and see if they match, please? Wondering if it's being truncated or other characters removed from it... Thanks, Steve
Jeremy Posted August 19, 2020 Author Posted August 19, 2020 @Steve G Firstly, I hope you had a good break! This is the ID from the file, which seems to match (1X8DvTeG03xEXT0Zr4oOVvv9t0LcX7MziJ9WBgzpxjsU). Interestingly I have set up a new integration recently with another Sheet and this does load the name but takes about 20/30 seconds to load the Sheet name in the node, maybe for this one it is timing out before returning the data?
Steve G Posted August 19, 2020 Posted August 19, 2020 @Jeremy Had a great time, thanks! You may be on to something there, this might be the amount of time it takes the Google Drive API to return the Sheet, and times out if it's not retrieved it in time... I'll do some further testing and let you know how I get on. Cheers, Steve
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now