@riichard-moore I get it now LOL.

@pablo-garcia we do have a tutorial here on how to create data visualization with Highcharts and Cloudbackend:
https://support.appdrag.com/doc/Using-highcharts-library

@joseph-benguira Cool, hit me up when it's done ^^

@thomasd nop, not all headers are making the cache vary, and most users will use chrome, safari or Firefox

Thank you !!!

This was a big help!!

Hey @Karol-W

"Data source Cloud Backend" is to configure which datasources are loaded on the page (don't load too many or your page will be slow)
"Triggers ->Cloud Backend" is to configure an action that will call a cloud backend function

Dynamic datasources are useful to generate pages based on url parameters, they are useless for this kind of interaction you want to do here.
So I would recommend you to remove that data source and replace it with a regular API call instead
We have more tutorials about generating dynamic content without dynamic datasources here: https://support.appdrag.com/doc/Creating-Dynamic-content-using-Factory
https://support.appdrag.com/doc/Creating-Dynamic-content-using-Visual-Factory

here you have a dropdown and you want to change the gallery content when the dropdown value is changed, so you should write some jquery code to capture the change on that SELECT dropdown $( "SELECT[name='YourSelectNameHere']" ).change(function() { var newVal = $("SELECT[name='YourSelectNameHere']").val() //Call your function to load data from the api and display it });

Thanks! you saved the day!

@thomasd it's displayed in the auto generated API function documentation (when you are editing a cloud function, click on Documentation on the right side)

@undefined Done, marked as solved 😉

I can confirm that variables in SQL are not supported on Cloud Backend

@wassim Excellent thank you 🙂

@pierre-sulpice yes, this search only on what is visible on screen, if you need to filter in the whole entries of your DB use the filters.

@Wassim thanks for you answer.

I agree that the file will be tricky to find but I still try to the basic "even hard to find it shouldn't be public when it's related to security", and it's literally for all ma security checks 😕

I thought about the other solution but I'm trying to develop something very easy to maintain for any developers even with a low formation for my clients, your solution itself is great and easy to use, I don't want to complexify it.

I think the third solution I will retain is to create a proxy route that will take care of this common code then call the adequate resource and return the result.

I think having private code outside of a route but still on AppDrag is the only major feature I miss right now !

I haven't said it in a while: Thanks for AppDrag in general, I'm really having a great time on it 🙂

See you soon,
Best regards,

Hi,
Ok I added a fix to handle them even if they're string instead of integers. It will be pushed in production tonight.

Hello @Daniel-Mulroy ,

Dropdown & Dropdown Multi Field Type are only in Cloud DB UI.
To enter content inside you have to create lists and assign a list to the column :

a82b3288-5f99-4444-b370-1941ae3cba44-image.png

a0e59966-4279-43e3-819d-a82c086d36eb-image.png

Then you'll be able to select items from your list
e554ffdb-1db7-4e70-9e97-c269fe7c58c1-image.png

It seems you think linked fields and dropdowns are the same but they aren't.

Linked fields are as their name suggest fields linked to another table Dropdowns are lists you manually create allowing users to select values from it. It can be used only in Cloud DB UI

@Pablo-Garcia

I'm confused by the word VALUE in your query. I am pretty sure that is causing the issue.

If you're coming from a different SQL platform, you should be aware that CloubBackend uses MySQL 5.8 via AWS Aurora, so your queries have to adhere to that syntax.

I think if you simply removed "VALUE" from most of your queries above things might start working 🙂

@Wassim

I'm doing that, but it's limited to 100KB per object string in the JSON.

@Joseph-Benguira suggested that I retrieve the page and parse the tags manually and then return only the HTML as the page, so I guess I'll have no other choice than to do that.

Hi,

I would use an npm package to read the uploaded file :

https://www.npmjs.com/package/csv-parser https://www.npmjs.com/package/csv-reader

And then generate the SQL request to insert it into your database.

@Joseph-Benguira soooorry got it thanks 🙂

@Joseph-Benguira excellent thanks 🙂 and can I upload a gatsby js frontend for it? If yes which option on the dashboard do I choose for that?

Hi,
Yep you can export your database to CSV and import it. There's no direct way or synchronous way to achieve it.

@Joseph-Benguira your plans around cloudgate sound phenomenal ☺️ +1

Hey Franck,
yes it's possible, when you configure your scheduling select "Every-week" in the recurrence type dropdown
you can then indicate the days of the week and hour

dc4a523b-ac9f-4b9b-a1de-1e6aad92c7ae-image.png

Hi Jean,

another option may be to try a csv to sql converter, i.e. https://www.convertcsv.com/csv-to-sql.htm

Then go to your Cloud Backend > Databases > New query

Screenshot 2021-03-17 at 22.27.18.png

The copy the sql code to create the table

Screenshot 2021-03-17 at 22.26.32.png

I've actually built my own tool to create this 'create table' sql code to quickly replicate FileMaker tables in AppDrag 🙂

I do see that when you sync it down, you have a 'config file' (api.json) with the relevant metadata.

Here's a sample:

"appId": "abcd-1234", "funcs": { "/": [ // filepath { "id": 1234, // function ID "name": "myGreatFunction", function Name "description": "", "type": "nodejs12.x", "contentType": "FILE", "method": "PUT", "ram": 128, "timeout": 15, "output": "JSON" }, //etc.

My suggestion is, maybe the fs pull can (either by default or with an arg) write the APIs in the correct folder structure, with the function names.

Then, when uploading, it can match the filenames/paths with the JSON config file in order to upload it back to the server in the right place.

This is a huge difference between something like AppDrag and Netlify or others. I love AppDrag but I'm spending a LOT of time trying to do simple things like sync my code to gitHub or work effectively locally in VS Code without copy/pasting code by hand back and forth.

@Daniel-Mulroy said in Rotating/Changing API Key:

Thanks @Wassim that helps.

Does that mean the environment vars are 'hardcoded' into the version of the script that is published?

more info here :
https://docs.aws.amazon.com/lambda/latest/dg/configuration-envvars.html

You define environment variables on the unpublished version of your function. When you publish a version, the environment variables are locked for that version along with other version-specific configuration.

Thank You Wassim.

https://www.npmjs.com/package/appdrag-cloudbackend

You can JSON.parse(response); and check numberOfAffectedRows.

Can you share a link to support@appdrag.com with the steps to reproduce?

@Wassim said in Is the AppDrag function name (or URL?) available from within an API Function?:

Seems a very good and practical way to do it. You can also manually define it in your API functions while setting sentry up no?

Yes, I could, but I'm looking for reusable / template code I can copy/paste very quickly between functions and/or use in my template library... so I don't want to think about it each time, just want it to work every time 🙂

For reference, here's my final code to get the function name both during testing "Try" in CloudBackend and also when the function is called 'normally':

module.exports.getFunctionInfo = (event, context) => { let fInfo = {}; // Try to extrapolate function info // sometimes the from-url is not available, so wrapping this in a try/catch block try { const httpMethods = ["GET", "POST", "PUT", "DELETE", "PATCH"]; var functionHandle = event.HEADERS['from-url'].split('/').slice(-1)[0]; // Get from URL if it's been called from the web for (let method of httpMethods) { // Get from parameters if it's been called from "Try" method, because above method will not work. Could also ignore errors if running from Try Now as they are likely development errors.... if (event[method] && event[method].APPDRAG_FUNCTION_NAME != null) functionHandle = event[method].APPDRAG_FUNCTION_NAME; } fInfo.functionHandle = functionHandle; } catch (e) { fInfo.functionHandle = ""; } fInfo.functionVersion = context.functionVersion; fInfo.functionName = context.functionName; return fInfo; };

Hello,
Exactly, thanks to you for finding this issue!
This has been corrected, it will be live tomorrow.

Hey, yes you can call it whatever you want as they are just variable names.
You just have to use the same name when using process.env.yourVariable. Your code will use the computed value of it so the name has no impact. (unless a library specifically use inside its code process.env.whateverVariable)

Hey Pierre, please ensure the email sender address configured in your whitelabel settings is validated or else indeed no emails will be sent
Another option is to clear the sender email address field in your whitelabel settings

@Wassim

Super, then I don't need to worry about that ✌

Hey Ugnius,

in the env variable settings, add a new env var, name it "googleJSON" for eg. but you can name it as you want
on the right side, as value, paste the whole text content of the json file you have from google.

var googleJSON = JSON.parse(process.env.googleJSON);

admin.initializeApp({
credential: admin.credential.cert({
projectId: googleJSON.project_id,
clientEmail: googleJSON.client_email,
privateKey: googleJSON.private_key
}),
databaseURL: "https://<DATABASE_NAME>.firebaseio.com"
});

Just a small thing, whenever you can you should avoid Google!
Google deprecates API and services every week and providing nearly zero warning to "customers", in fact they have no respect at all for developers using their services and it's nearly impossible to talk with someone there. So if you want your service to be down in the next 6 months because it's deprecated without any notice ... sure go with google 🙂